DISTINCTCOUNT except specific value

[Gaël]

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.

[kcantor · Accepted solution]

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.

[Gaël]

Thank you very much everybody.

[mitsu]

One of the ways you can handle this is by using calculate function . 

=Calculate(DitinctCount (<<>>),<<Filterexpresion >>)