Report Portal

SCOPING at different granularities in DAX (Part II)

As mentioned on the prior post on the topic (available here), the DAX calculation that mimics MDX scope behavior requires a certain 'filter arrangement' to work properly. In other words, it actually expects a display hierarchy - otherwise it will not yield the correct results. Can we overcome this to more closely resemble MDX behavior? Interestingly, yes - is it possible, using a variation of the formula exposed on the prior entry.

Read more...

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.