Help with REMOVEFILTERS needed

[dkernen2]

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

@dax

[Ashish_Mathur · Accepted solution]

Hi,

This measure works

Cases WRT Auditor = CALCULATE([Cases],ALLSELECTED(FINANCIAL_STATEMENTS[Auditor ID]))

Hope this helps.

[dkernen2]

Thank 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.

[v-bofeng-msft]

Hi @dkernen2 ,

Please try:

Cases WRT Auditor = CALCULATE([Cases],ALLSELECTED())

Best Regards,

Bof

[lbendlin]

Cannot reproduce.  Something else must be going on (for example in your [Cases] measure).

[dkernen2]

My Cases Is using COUNTROWS().  Could that be the problem?

[lbendlin]

Countrows of what? The Cases table?  How is it wired in the data model?