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.
I'm trying to show row subtotals in a matrix but I don't want to show subtotals for all rows, just for the one selected row, TestId in this instance.
Is this possible? I did try to use the "Per row level" toggle under the row subtotals section but that does not seem to be working.
Below are screenshots of my matrix and the list of rows and values I am using for this matrix. Marked in green are the subtotals that I intend to keep, but I want to remove the subtotal rows marked in red.
Thanks.
Solved! Go to Solution.
@ChrisElu , Per row level is there.
Test ID will remove grand total
Test will remove total of Test ID level and so on
The same is for column-level totals
if you want to remove it for measure then use isinscope
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
@ChrisEluunfortunately, I'm new to PowerBI so I'm unable to figure out what the DAX should be. I've the exact same use case as yourself. Would it be possible for you to let me know the exact DAX query?
@ChrisElu , Per row level is there.
Test ID will remove grand total
Test will remove total of Test ID level and so on
The same is for column-level totals
if you want to remove it for measure then use isinscope
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |