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! Learn more
I want to see the summation of all four rows(for # of attorney) in front of the # of attorney and so on for all the subheaders like Practice area. I tried using summarise column but maybe by DAX query is wrong.
Hi @Anonymous
Do you want the row subtotals in Matrix visual? Subtotals and grand totals with matrix visuals
Best Regards,
Community Support Team _ Jing
@Anonymous , I think you have to use isinscope
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
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.
| User | Count |
|---|---|
| 84 | |
| 49 | |
| 38 | |
| 31 | |
| 30 |