Forum Discussion
Solved
DISTINCTCOUNT with condition
Hi All, I am surprised this question hasn't come up more - I found a similar post but it didn't the solution didn't work for my situation. So, I have a PBI report stuffed with measures that l...
vickyw ,
I believe the KeepFilters function will help in this situation:
Total Red Cases = CALCULATE(DISTINCTCOUNT('All Cases'[Case Number]), KEEPFILTERS('All Cases'[CaseColour] = "Red"))https://learn.microsoft.com/en-us/dax/keepfilters-function-dax
for a completed explanation.Hope this is what you are aiming for.
Regards,
It absolutely does! Thank you so much!! 😄