Scorecard needs to show 0 if no value

[Curious_data]

Hello!

Please advise how to add ISBLANK or adjust the measure so the scorecard will not show BLANK (shows 0) if there is no value.

Ready Units = CALCULATE(

    DISTINCTCOUNT('Table Name'[UNIT_NO]),

    'Table Name'[Unit Status] IN { "Ready" }

)

Thank you!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but please try something like below whether it suits your requirement.

Ready Units =
VAR _result =
    CALCULATE (
        DISTINCTCOUNT ( 'Table Name'[UNIT_NO] ),
        'Table Name'[Unit Status] IN { "Ready" }
    )
RETURN
    IF ( ISBLANK ( _result ), 0, _result )