Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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.