topic Scorecard needs to show 0 if no value in DAX Commands and Tips

Scorecard needs to show 0 if no value

Curious_data — Mon, 25 Mar 2024 03:13:31 GMT

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!

Re: Scorecard needs to show 0 if no value

Jihwan_Kim — Mon, 25 Mar 2024 04:14:14 GMT

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 )