Forum Discussion
ALL function on lower level of aggregation
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.
- Anonymous4 years ago
Hi Anonymous ,
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
1 Reply
- AnonymousNot applicable
Hi Anonymous ,
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