Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.