Forum Discussion
Solved
DISTINCTCOUNT except specific value
Hi, I'm using in a dinamic table the function DISTINCCOUNT but this command counts the null value too: Here I'm using the DISTINCTCOUNT and the result is wrong because it is counting the ...
Try this:
CALCULATE(DISTINCTCOUNT([Ginclus]), [Ginclus]<>" ")
Of course you may have to make it: CALCULATE(DISTINCTCOUNT(Ginclus]), [Ginclus]>0) if you are using a zero instead of a blank.
Keep in mind, I don't know the absolute names of your data and these were just pulled from the image.
Try this:
CALCULATE(DISTINCTCOUNT([Ginclus]), [Ginclus]<>" ")
Of course you may have to make it: CALCULATE(DISTINCTCOUNT(Ginclus]), [Ginclus]>0) if you are using a zero instead of a blank.
Keep in mind, I don't know the absolute names of your data and these were just pulled from the image.
Thank you very much everybody.
