Forum Discussion

rlooney's avatar
rlooney
Frequent Visitor
7 years ago
Solved

Count distinct of nulls in Power BI doesn't work like SQL Server

We had a customer run across this while validating data.     We see an idea in the old forum that indicates others have seen this problem as well, but I don't see any staff feedback to note that th...
Data Modeling
  • Anonymous's avatar
    Anonymous
    7 years ago

    rlooney,

    I have got response from PG that this behavior is by design, please vote up the idea you have mentioned above.

    Regards,
    Lydia

  • rlooney's avatar
    rlooney
    7 years ago

     

     Anonymous - Thank you for checking on this.  I have voted for the idea and this can be closed.

     

    Also, for others that might see this, one of the forum questions about this suggests adding a filter to the data to exclude the (blank) data.  Doing that will produce a count and count(distinct) that is consistent with SQL Server.  Just keep in mind what level you're filtering that data at as that might cause other problems if not fully accounted for.

rlooney's avatar
rlooney
Frequent Visitor
7 years ago

 

 Anonymous - Thank you for checking on this.  I have voted for the idea and this can be closed.

 

Also, for others that might see this, one of the forum questions about this suggests adding a filter to the data to exclude the (blank) data.  Doing that will produce a count and count(distinct) that is consistent with SQL Server.  Just keep in mind what level you're filtering that data at as that might cause other problems if not fully accounted for.