Forum Discussion
Helper IProblem using DISTINCTCOUNT with multiple filters
I tested it on my local environment by using your sample data and formula, everything works fine.
Regards,
Charlie Liao
Got it. It works properly as a Measure, but not as a Calculated Column. See this post for reference:
https://community.powerbi.com/t5/Desktop/Distinct-Count-not-working/td-p/183519
Microsoft Employee
I tested it on my local environment by using your sample data and formula, everything works fine.
Regards,
Charlie Liao
ineedhamThis is strange.
Here's a link to the PBIX file:
https://drive.google.com/open?id=1uPhi9HIF-cz8ikIJL0AfMIbKuk7WaNzM
Also, I tried ditching the larger dataset, and only importing the 14 records in the preview. I still get 1400 using the formulas. It's as if DISTINCTCOUNT is being treated as COUNT in my formulas.
- ineedham
Got it. It works properly as a Measure, but not as a Calculated Column. See this post for reference:
https://community.powerbi.com/t5/Desktop/Distinct-Count-not-working/td-p/183519