Forum Discussion

SaganBigRedDog's avatar
SaganBigRedDog
Helper I
9 years ago
Solved

Showing zero values?

Hi!   So I have this chart (left) And I want it to show 0% for the blank values.   The measure formula is: Discrepancy Percent =  CALCULATE (   DISTINCTCOUNT('! NEW DISCREPANCY REPORT Last Mo...
Need Help
  • SaganBigRedDog's avatar
    SaganBigRedDog
    9 years ago

    Thanks, Charlie! I figured out the issue was with one of my tables with the FSS and District fields.  I used your formula after correcting and it worked! Thanks!!

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

SaganBigRedDog,

 

I have tested it on my local, we can use ISBLANK function to display 0 if the value is blank.

Measure = IF(ISBLANK(DISTINCTCOUNT(Table1[Column1])),0,DISTINCTCOUNT(Table1[Column1]))

 

You can use the DAX below for you first measure.

measure 1 = IF(ISBLANK(DISTINCTCOUNT('! NEW DISCREPANCY REPORT Last Month'[Discrepancy Bis IDs])),0,DISTINCTCOUNT('! NEW DISCREPANCY REPORT Last Month'[Discrepancy Bis IDs]))

 

If the issue persists, please provide us some sample data, so that we can make further analysis.

 

Regards,

Charlie Liao

SaganBigRedDog's avatar
SaganBigRedDog
Helper I
9 years ago

Thanks, Charlie! I figured out the issue was with one of my tables with the FSS and District fields.  I used your formula after correcting and it worked! Thanks!!