Forum Discussion
dkernen2
Helper II
Helper IIHelp with REMOVEFILTERS needed
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:
Cases WRT Auditor = CALCULATE([Cases],REMOVEFILTERS(AUDITORS[Auditor ID]))
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 |
Hi,
This measure works
Cases WRT Auditor = CALCULATE([Cases],ALLSELECTED(FINANCIAL_STATEMENTS[Auditor ID]))Hope this helps.
7 Replies
- Ashish_Mathur
Super User
Hi,
This measure works
Cases WRT Auditor = CALCULATE([Cases],ALLSELECTED(FINANCIAL_STATEMENTS[Auditor ID]))Hope this helps.
dkernen2Thank you! I see that I was mixing the lookup Auditor ID with the fact table Auditor ID. I appreciate the help!!
- Ashish_Mathur
You are welcome.
- lbendlin
Cannot reproduce. Something else must be going on (for example in your [Cases] measure).
