SCOPING at different granularities in DAX (Part II)

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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.