Forum Discussion

yakovlol's avatar
yakovlol
Icon for Resolver I rankResolver I
2 years ago

To add zero values where is blank in Matrix

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 

Need Help
Tips and Tricks

2 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    2 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.