Hiding Blanks in card measure results

[Mohsen_2020]

Hi Team, 

is there anyway to Hiding Blanks in card measure results ?

Regards,

Mohsen

[CNENFRNL]

Hi, @Mohsen_2020 , consider replacing blank() with ""(zero-length string)?

Coaching Score =
VAR __score = ...
RETURN IF ( ISBLANK ( __score ), "", __score )

[Mohsen_2020]

could you please tell me the how to?

[v-rzhou-msft · Accepted solution]

Hi @Mohsen_2020 

I agree with  CNENFRNL . In addition to CNENFRNL 's reply, CNENFRNL 's measure works well, and I will explain how to do this by a test.

I build a easy table to have a test.

If we build a measure to calculate the Value when Category = B, and show the measure in Card, it will show(Blank) like your screenshot .

So we can use If function to replace (Blank) with others like 0, "" (Strings).

More info about Var and If function : Var, IF 

Measure = 
Var _B = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Category]="B"))
return
IF(_B = BLANK(),"",_B)

Result:

You can download the pbix file from this link: Hiding Blanks in card measure results

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.