The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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/
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
181 | |
82 | |
63 | |
47 | |
43 |