How to fill the blanks with the default value . These two are the calculated measures . I have no data in backend.How to fill the blanks with default value ("0").Any solution ?
Hi, @Ayushi_10
Let me give you an example.
Measure = SUM('Table'[Value])+0
If you want 0 to replace the blank value, you can add "+0" to the end of the measure formula.
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.
Hi, @Ayushi_10
Let me give you an example.
Measure = SUM('Table'[Value])+0If you want 0 to replace the blank value, you can add "+0" to the end of the measure formula.
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.
Hello @Ayushi_10 ,
check this solution https://community.fabric.microsoft.com/t5/Desktop/Replacing-Blanks-with-0/m-p/418624
Proud to be a Super User! |  |
Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
