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!!

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

maybe do a check to see if its blank first? but i am not sure if that creates the same issue

test =
IF (
ISBLANK (
CALCULATE (
DISTINCTCOUNT ( '! NEW DISCREPANCY REPORT Last Month'[Discrepancy Bis IDs] )
/ DISTINCTCOUNT ( '! NEW ALL 401 OPEN Last Month'[Submission Bis IDs] )
)
),
0,
CALCULATE (
DISTINCTCOUNT ( '! NEW DISCREPANCY REPORT Last Month'[Discrepancy Bis IDs] )
/ DISTINCTCOUNT ( '! NEW ALL 401 OPEN Last Month'[Submission Bis IDs] )
)
)

SaganBigRedDog's avatar
SaganBigRedDog
Helper I
9 years ago

Hi,

 

Yes, it created the same issue.

 

Technically, those blank records are "0%" values.

 

ANy idea how to resolve?