To add zero values where is blank in Matrix

[yakovlol]

Hello team,

If there are any workarounds how can I instead of blank values put zero?

So my matrix table is below and where there are blank values there is No row in my fact table. That's why it's blank in matrix because my fact table is appending data from 2 tables. 
I cannot merge two tables only append

But I don't know how to fix that and put 0 instead of blank

+0 is not working in my case it puts zero's everywhere

Much appriciete for the help.

Thanks 

[Anonymous]

Hi,Idrissshatila ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@yakovlol .I am glad to help you.

In fact, Idrissshatila makes excellent suggestions. Here are the tests I have performed and I hope they help you.

You can try to re-add the measure in place of the original area effect in the Value area.
like this.

M_result = 
IF(MAX('Table'[Sales])=BLANK(),0,SUM('Table'[Sales]))

change to this:

Here is my test data:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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

[Idrissshatila]

Hello @yakovlol ,

so it's either you do if isblank the record then 0 but it puts zero everywhere that is blank or stay with blank record, there's no between.