Avoiding seeing blank in a card?

[ovonel]

I have the next measure in a cube in SSAS:

CALCULATE (

DISTINCTCOUNT(‘FactTable’ [Ticket Number]),

 FILTER(‘FactTable’, ‘FactTable’[Amount]>0)

)

But, when I use it in Power BI for a card, I see blank when the measure is 0.

Why is it displaying blank?? How can I make it display 0.

[Samarth_18]

Hi @ovonel 

You can try below code:-

measure =
VAR result =
    CALCULATE (
        DISTINCTCOUNT ( 'FactTable'[Ticket Number] ),
        FILTER ( 'FactTable', 'FactTable'[Amount] > 0 )
    )
RETURN
    IF ( result = BLANK (), 0, result )

Thanks,

Samarth

[TheoC]

@Samarth_18  I like this option better than using +0 as it allows the user to further expand on the measure if needed. +0 works fine but it doesn't have the "agility" of using "If ( result = BLANK ()" or " IF ( ISBLANK (result) , 0...".  Well done on this response.

[jppv20 · Accepted solution]

Hi @ovonel 

Ty adding +0 at the end of the formula:

CALCULATE (

DISTINCTCOUNT(‘FactTable’ [Ticket Number]),

 FILTER(‘FactTable’, ‘FactTable’[Amount]>0)

) +0

Jori

If I answered your question, please mark it as a solution to help other members find it more quickly.