Forum Discussion

Helper I

3 years ago

replacing 0 to text in table

I would like to replace all the 0 to 'Not provided' The above value column that I up-pivoted different columns' values. As you can see there are some 0, I would like to make it to 'Not provi...

Need Help

v-yalanwu-msft

Community Support

3 years ago

Hi, henry24007 ;

You could create a measure.

measure =
VAR _sum =
    SUM ( 'table'[value] )
RETURN
    IF ( _sum = 0, "Not provided", FORMAT ( _sum, "0" ) )

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.