Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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