ALL function on lower level of aggregation

[gregsuash]

Hi guys,

I am newbie to PBI and trying to solve one thing. 

I want to see the values in the Matrix when the values for TOTAL for whole time horizon is greater than some value (eg. 100 000). 

So I created a measure with simple CALCULATE and ALL function inside and on the lowest level used in Matrix it is working fine. 

When I add it as a filter it works as I expect - I see only 2 categories 

But in the main table I want to see it only on the Country level - I want to get rid of the business here but then it is looking for it on the higher level of aggregation and I see such a values:

How can I create a measure that will look on the lowest level in my data to use it properly this ALL function but show the values on the higher level of aggregation? 

I will be very grateful for any tips. 

[Anonymous · Accepted solution]

Hi @gregsuash ,

You may consider to use isinscope() or isfiltered() function to return different measures for different levels.

https://docs.microsoft.com/en-us/dax/isinscope-function-dax 

https://docs.microsoft.com/en-us/dax/isfiltered-function-dax 

For example:

measure3 = IF(ISINSCOPE(column),[measure1],[measure2])

Best Regards,

Jay