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.
How do we get column total of subcategory for a matrix?
I want to show main category CT% at overall level and subcategory CT% at drilled down level.
@amaddala , Once you have the option on the visual pane, right-click on a measure to be shown as % of total or subtotal.
Another method is have % of total and % subtotal as measures as use isinscope to switch between these two
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
% of total and sub total
https://www.youtube.com/watch?v=6jTildcV2ho
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 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |