Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Distinct count rows that are not blank!

Hey everyone, How can I count all the distinct values in a column except the blank(null) values? I tried several things but nothing works.  
  • Anonymous's avatar
    Anonymous
    9 years ago

    =calculate( distinctcount(MyTable[MyColumn]), MyTable[MyColumn] <> BLANK())

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hey Anonymous

If the distinctcount of a column is equal to zero then distinctcount returns BLANK(null). Can I fix this to show 0 instead of null?

Oxenskiold's avatar
Oxenskiold
Advocate I
9 years ago

Hi Anonymous,

 

you can use this:

 

=
CALCULATE ( DISTINCTCOUNT ( MyTable[MyColumn] ), MyTable[MyColumn] <> BLANK () )
    + 0

 <Blank> + 0 equals 0

 

Kind regards

Oxenskiold

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks Oxenskiold! :))