Trying to get card visual to display nothing instead of Blank

[Anonymous]

I have a Card visual on my page, showing the total tax amount. It currently says (Blank) when there is no value to display.

Instead of Blank, I would like it to display nothing. I tried applying the following measures to the Card View as a filter:

    Replace Blank With Nothing = IF(ISBLANK(SUM ( YearlySales[Taxes] )),"",SUM ( YearlySales[Taxes] ))

    Replace Blank With Nothing = IF((ISBLANK(SUM ( YearlySales[Taxes] )) || (SUM ( YearlySales[Taxes] ) = 0)),"",SUM ( YearlySales[Taxes] ))

But it still says Blank when there is nothing to display. Any suggestions?

[Anonymous]

I was incorrectly trying to apply the measure as a filter, instead of a value, and this is why the measure was not working

[Anonymous]

[Base Measure] = SUM( YearlySales[Taxes] )

[Measure For Card] =
	COALESCE(
		[Base Measure],
		""
	)
	
// Bear in mind that if a measure
// returns a numeric BLANK(), its value is
// treated as 0, so this is true
// [measure] = 0. You don't have to
// check for many conditions as you do
// in you second measure.

Best

D

[harshnathani]

Hi @Anonymous 

Try

 Replace Blank With Nothing = IF(SUM ( YearlySales[Taxes] ) = BLANK(),0,SUM ( YearlySales[Taxes] ))

https://community.powerbi.com/t5/Desktop/Make-Card-Visual-show-0-not-Blank/m-p/403353

Regards,

HN

[Anonymous]

This did not work either