Forum Discussion
dkernen2
Helper II
1 year agoHelp 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...
- 1 year ago
Hi,
This measure works
Cases WRT Auditor = CALCULATE([Cases],ALLSELECTED(FINANCIAL_STATEMENTS[Auditor ID]))Hope this helps.
dkernen2
Helper II
1 year agoThank you! I see that I was mixing the lookup Auditor ID with the fact table Auditor ID. I appreciate the help!!
Ashish_Mathur
Super User
1 year agoYou are welcome.