Forum Discussion

Sagejah9's avatar
Sagejah9
Icon for Helper III rankHelper III
3 years ago
Solved

Replacing blanks with zeros

Hi. I am trying to replace the blanks with zeros in a measure that's inside a filtered table. The measure is doing a count on rows. I used if(isblank(variable),0,variable) but filling in blanks with ...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Sagejah9 

     

    You can try the following methods.
    Sample data:

    Measure = SUM('Table'[Value])+0

    Hope this method helps you.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Sagejah9 

 

You can try the following methods.
Sample data:

Measure = SUM('Table'[Value])+0

Hope this method helps you.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.