Filtered Table show 0 instead of Blank

[AllanBerces]

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.

Replace Blank to Zero =

VAR Quantity = SUM('Article no. and Location'[Quantity])

RETURN

IF(ISBLANK(Quantity),0,Quantity)

Thank you

[v-xuxinyi-msft]

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.

[Rygar]

Try this instead of IF:

Quantity = SUM('Article no. and Location'[Quantity])+0

[AllanBerces]

Hi @Rygar 

Same result it di not filter the table, zero values appeared on all the project.

Thank you

[lucadelicio]

Try to add + 0 to force the conversion type

[AllanBerces]

Hi @lucadelicio 

Same result zero appeared on all the project.

Thank you

[lucadelicio]

accept as a solution

[AllanBerces]

Hi @lucadelicio 

Still my concern didnt solve by adding 0, zero appeared on all the project. and not on filtered project only

Thank you

[lucadelicio]

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.