Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you all for your reply. please let me reformulate my inquiry. look at this table.

I have a total mile goal set by week which is 3000 for each driver. the total mile for each driver is the sum of miles for everyday. so my result was blank because power bi was evaluating mile/day there was no day where a driver reached 3000 miles. what I need your help with now is how to sum the daily miles in my filter? I am using this formular but it doesn't work.

 

thanks,

Ulrich