Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Good day,
Can anyone pls correct my measure, i want to show 0 instead of blank on my filtered table. i used below measure but zero show for all the project.
Hi @AllanBerces
You can try to modify the formula as follows.
Replace Blank to Zero =
VAR Quantity = SUM('Article no. and Location'[Quantity])
RETURN
IF(Quantity = BLANK() || Quantity = "", 0, Quantity)
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try this instead of IF:
Quantity = SUM('Article no. and Location'[Quantity])+0
Hi @Rygar
Same result it di not filter the table, zero values appeared on all the project.
Thank you
Try to add + 0 to force the conversion type
accept as a solution
Hi @lucadelicio
Still my concern didnt solve by adding 0, zero appeared on all the project. and not on filtered project only
Thank you
I don't understand the problem. Try to create 2 diffrent measures one to use in the filtered parte and one to use in all the project.
Let me know.
It's better to upload the pbix to solve easly.
User | Count |
---|---|
92 | |
86 | |
66 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |