Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How can i remove blanks on card visual using discont count

I am using this dax formular here but when there is a blank / null the card visual  shows "Blank" i have tried every trick and i cant get rid of the blank. anyone know how to get rid of it?

Count =
COALESCE(CALCULATE(DISTINCTCOUNT('WORKORDER'[SYSTEM])),0)
Need Help

2 Replies

  • alena2k's avatar
    alena2k
    Icon for Resolver IV rankResolver IV
    3 years ago

    hi Anonymous 
    I usually add variable is check if it is blank:
    Count = 

    VAR tmp = COALESCE(CALCULATE(DISTINCTCOUNT('WORKORDER'[SYSTEM])),0)

    RETURN IF(ISBLANK(tmp), 0, tmp)
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      still getting a blank.