Forum Discussion
M_SBS_6
Helper V
Helper VReplace BLANK with 0
Hi, I have a table which outputs values, but where we don't have a value, the output returned is blank. Is there anything I can do within my existing logic to return a 0 value instead of Blank...
Hi M_SBS_6 ,
Please try if this formula helps:
Measure = VAR _SUM = CALCULATE ( SUM ( 'apps'[spend] ), 'apps'[sys] = "T" ) RETURN IF ( _SUM = BLANK (), 0, _SUM )Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yanjiang-msft
Community Support
Community SupportHi M_SBS_6 ,
Please try if this formula helps:
Measure =
VAR _SUM =
CALCULATE ( SUM ( 'apps'[spend] ), 'apps'[sys] = "T" )
RETURN
IF ( _SUM = BLANK (), 0, _SUM )
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.