Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
dkernen2
Helper II
Helper II

Help with REMOVEFILTERS needed

I have a dataset that creates a matrix with counts that looks like this:

 

AuditorNoYesTotal
230333
46 6
5112
Total37441

 

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

AuditornoYesTotal
237441
437441
537441
Total37441


@dax

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

This measure works

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

Hope this helps.

Ashish_Mathur_0-1728961201720.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

7 REPLIES 7
Ashish_Mathur
Super User
Super User

Hi,

This measure works

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

Hope this helps.

Ashish_Mathur_0-1728961201720.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-bofeng-msft
Community Support
Community Support

Hi @dkernen2 ,

 

Please try:

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

vbofengmsft_1-1728956813910.png

 

Best Regards,

Bof

 

lbendlin
Super User
Super User

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

 

lbendlin_0-1728934586428.png

 

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

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.