March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
97 | |
85 | |
69 | |
61 |
User | Count |
---|---|
138 | |
116 | |
114 | |
99 | |
98 |