Forum Discussion

ineedham's avatar
ineedham
Icon for Helper I rankHelper I
8 years ago
Solved

Problem using DISTINCTCOUNT with multiple filters

I would like to calculate the distinct count of values in a column on a filtered list to use in a formula.   I’ve read the other posts on this, but am still stumped.   I have a larger dataset tha...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

ineedham,

 

I tested it on my local environment by using your sample data and formula, everything works fine.

 

Regards,

Charlie Liao

ineedham's avatar
ineedham
Icon for Helper I rankHelper I
8 years ago

This 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.