Forum Discussion

Sagejah9's avatar
Sagejah9
Helper 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 zeros including all rows and ignoring the filters that were applied in the slicer. Anyone has con e across this or has a solution? Thanks

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.

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Community 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.