Forum Discussion
How do I avoid to count the empty value?
Hi, I want to count how many types in the table below: Name Type A 1 B 2 C 2 D 1 E I used the code following: Type(#) = IF(ISBLANK(DistinctCount(Sheet1[T...
Hi, Anonymous
There is a function called DISTINCTCOUNTNOBLANK which avoid count blank value.
So to count of Type, just write a measure DISTINCTCOUNTNOBLANK( Table[Type] )
Hope it will work for you.
Thank you!
Hi, Anonymous
There is a function called DISTINCTCOUNTNOBLANK which avoid count blank value.
So to count of Type, just write a measure DISTINCTCOUNTNOBLANK( Table[Type] )
Hope it will work for you.
Thank you!