How to solve card show blank ?

[Anonymous]

I use card to show number but if = 0 , it show blank.

I want to show 0 

Please guide about it.

[lkalawski]

Hi @Anonymous 

You need to use a measure and use IF(ISBLANK([number]), 0 , [number] ).

Please share want you want to achieve and sample of data and then I can help you.

Proud to be a Super User. If I helped, please accept the solution and give kudos!  Linkedin

[Anonymous]

@lkalawski  How to use measure?

Sorry for not understand you.

I'm a newbie.

[lkalawski · Accepted solution]

@Anonymous 

Please share your sample data and screen how you are creating the card. 

With this information, a blank will appear for Category 2:

   

To avoid the blank from appearing, create a measure:

Value without blank = 
IF ( ISBLANK ( MAX ( 'Table'[Value] ) ), 0, MAX ( 'Table'[Value] ) )

and then use it in Card.

Proud to be a Super User. If I helped, please accept the solution and give kudos!  Linkedin

[Anonymous]

@lkalawski Now I use measure in card as below.

CALCULATE(

    COUNT ( 'Before 2021'[Status(2021)] ),

FILTER (

'Before 2021',

'Before 2021'[Status(2020)] <> "A"

&& 'Before 2021'[Status(2021)] = "A"

)

)

How to edit it?