Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a dataset that creates a matrix with counts that looks like this:
Auditor | No | Yes | Total |
2 | 30 | 3 | 33 |
4 | 6 | 6 | |
5 | 1 | 1 | 2 |
Total | 37 | 4 | 41 |
This is the DAX that does NOT do what I want:
I want to create a measure that gives subtotals irrespective of auditor. I want it to look like this, but I am doing something wrong. Can you please assist? Link to sample file: https://kauffman.box.com/s/2n6ccf18xkfzrmxopltujibbasxeqbrr
Auditor | no | Yes | Total |
2 | 37 | 4 | 41 |
4 | 37 | 4 | 41 |
5 | 37 | 4 | 41 |
Total | 37 | 4 | 41 |
Solved! Go to Solution.
Hi,
This measure works
Cases WRT Auditor = CALCULATE([Cases],ALLSELECTED(FINANCIAL_STATEMENTS[Auditor ID]))
Hope this helps.
Hi,
This measure works
Cases WRT Auditor = CALCULATE([Cases],ALLSELECTED(FINANCIAL_STATEMENTS[Auditor ID]))
Hope this helps.
Thank you! I see that I was mixing the lookup Auditor ID with the fact table Auditor ID. I appreciate the help!!
You are welcome.
Cannot reproduce. Something else must be going on (for example in your [Cases] measure).
My Cases Is using COUNTROWS(). Could that be the problem?
Countrows of what? The Cases table? How is it wired in the data model?
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
71 | |
70 | |
43 | |
31 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |