Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to remove BLANK on vard visual

I have a card visual based on this DAX  logic, however whenever there is no values (results) i keep getting  BLANK on the card visual- i tried appending a zero at the end of teh logic but that  is not working. anyone else has a suggestion?

OrderCount =
CALCULATE(DISTINCTCOUNT('sales'[orders]))+0
Need Help

5 Replies

  • Syk's avatar
    Syk
    Resident Rockstar
    3 years ago

    What you have should work..

    You can also try the coalesce function which returns the first value that is not blank. This should also keep it from saying (Blank)

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Still getting a BLANK-  I tried all the above suggestions and still not getting the desired output

      • DOLEARY85's avatar
        DOLEARY85
        Resident Rockstar
        3 years ago

        Do you have a copy of the PBIX file you could share?