Forum Discussion

dkernen2's avatar
dkernen2
Icon for Helper II rankHelper II
2 years ago
Solved

Help 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 doe...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    This measure works

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

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

This measure works

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

Hope this helps.

 

  • dkernen2's avatar
    dkernen2
    Icon for Helper II rankHelper II
    2 years ago

    Thank you!  I see that I was mixing the lookup Auditor ID with the fact table Auditor ID.  I appreciate the help!!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      2 years ago

      You are welcome.