Forum Discussion
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 empty value:
With "No Resume"...
Is it possible to configure the DISTINCTCOUNT to avoid to count the empty value (or a specific value to define)?
Thanks.
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.
3 Replies
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.
One of the ways you can handle this is by using calculate function .
=Calculate(DitinctCount (<<>>),<<Filterexpresion >>)
