Forum Discussion
Distinct Count with filter
Hello Guys, I am doing a distinctcount with filter on a column, power bi doesn't return any syntax error but there is no value in the result. I know for sure that there scould be something in the...
Hi Anonymous ,
I have test with your measure, it works on my side:
It's suggested to first check your dataset by applying simple filter like "TOTAL MILES is 3000" as HashamNiaz said.
If it does not make sense,please share me with your pbix file after removing sensitive data.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous !
Please try filtering your DSM table where [Total Miles] = 3000 from Data view and see if it retunrs any rows;
Alternatively you can try below DAX to check your measure;
ACHIEVED GOAL = CALCULATE(DISTINCTCOUNT(DSM[Driver]), FILTER(DSM, DSM[TOTAL MILES] = 3000))
Regards,
Hasham