Forum Discussion

arnomics's avatar
arnomics
Icon for Helper I rankHelper I
2 years ago
Solved

Distinct Count based on Multiple TRUE() conditions from 2 Columns

Hi all,   I have been unable to come up with a DAX Measure to caulclate a Distinct count of Customer IDs where 2 conditions are TRUE ().  Below is a Customer ID where the 2 conditions are TRUE i.e...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

look at my solution maybe it will help you

arnomics's avatar
arnomics
Icon for Helper I rankHelper I
2 years ago

Thanks for that!

 

I initially ran into a memory error. But adding Visual Filters helped solve that & I can now see the count as expected.