How to remove BLANK on vard visual

[Anonymous]

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

[luiguiwong]

IF(COUNTA(SICTEC[CLASE])=0,"0")

[Syk]

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]

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

[DOLEARY85]

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

[Anonymous]

Its a live data unfornately i cant share