Forum Discussion

brendaivett's avatar
brendaivett
Advocate II
9 years ago
Solved

How to not count the null/empty value in visualizations

Hi,   I just noticed that in my visualizations, when I use the Count Distinct to display values, it's actually counting one more for the Null/Empty values. I tried making the values "" or Null, fro...
Need Help
Tips and Tricks
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    brendaivett

     

    A fast way is add the column in visual level filter and unselected Blank.

     

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

i think you need to use this function

 

COUNTAX Function (DAX) The COUNTAX function counts nonblank results when evaluating the result of an expression over a table. That is, it works just like the COUNTA function, but is used to iterate through the rows in a table and count rows where the specified expressions results in a nonblank result.

 

https://msdn.microsoft.com/en-us/library/ee634219.aspx?f=255&MSPPError=-2147217396

brendaivett's avatar
brendaivett
Advocate II
9 years ago

Hi,

 

I used DISTINCTCOUNT for a measure, but in this case it's for showing the count number of records in a chart or table, so that the user can see the total count and if they want to see the records that add to it, just use the "see records" option.

 

 

In the case I'm testing, I have 1608 different values among several records, and there are some Null values, and the count is showing 1609, so I'm assuming is counting the "distinct empty value".

 

Thanks!

 

Brenda

 

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    brendaivett

     

    A fast way is add the column in visual level filter and unselected Blank.

     

    • sajidhussain's avatar
      sajidhussain
      Frequent Visitor
      8 years ago

      Hi Vvelarde

       

      I am using calculated measure and this filtering is not working .

       

      Could you please help ?

       

      Sajid

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        i'm in the same situation of this post and it seems there is no solution yet

         

        basically the COUNT DISTINCT in the graphs sums also the BLANK even if i was able to subtract them from the table!