Forum Discussion

Gaël's avatar
Gaël
Icon for Advocate II rankAdvocate II
10 years ago
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 ...
  • kcantor's avatar
    kcantor
    10 years ago

    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.

mitsu's avatar
mitsu
Icon for Resolver IV rankResolver IV
10 years ago

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

 

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