Filtering Matrix on the highest level of hierarchy

[CarlsBerg999]

Hi,

I have a PowerBI Matrix that has two levels of hiearchy. I want to filter on the highest level. The Filter i want to build is "Show all customers with Sales over 100€". How do I do this? If i set a filter for 100€ on the filter's pane, in the example below, it would filter away Project 1 from Customer 1 and Project 4 from Customer 2. This will lead to an incorrect situation, because i just wanterd to remove Customer 2.  

Thanks for the help! 

[v-angzheng-msft · Accepted solution]

Hi, @CarlsBerg999 

Try to create a measure below:

Over 100 =
VAR _SumOfMeasure =
    CALCULATE ( SUM ( 'Table'[Measure] ), ALLEXCEPT ( 'Table', 'Table'[Customer] ) )
RETURN
    IF ( _SumOfMeasure >= 100, "True", "False" )

Assign it to the visual filter and show items when the value is “True”

Sample:

Result:

Please refer to the attachment below for details

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@CarlsBerg999 

Create a measure that calculates the total ignoring the Product and assign to the visual filter in the filter pane and set it equal to 1:

Over 100 Customers = 

INT(CALCULATE(SUM(Table[Measure]),REMOVEFILTERS(Table[Project])) > 100 )