Forum Discussion
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.
=calculate( distinctcount(MyTable[MyColumn]), MyTable[MyColumn] <> BLANK())
Great work and thank you! Seems like not counting the blanks would be implied. Yet another reason I'm having a hard time converting from MD to tabular