Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
@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 )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
106 | |
87 | |
77 | |
69 |
User | Count |
---|---|
123 | |
112 | |
95 | |
83 | |
73 |