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

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