Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Empty values in matrix visual

Hi, I have this Matrix:

I created a measure and a colum to fill blanks 

cantidad stock blancos = IF(ISBLANK([cantidad stock medida]);0;[cantidad stock medida])
but it's not working...I think it has to do that I´m opening Parent_Item by branch...how could I fill blanks with 0 ?
 
Thanks in advance!
Need Help
Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You can simply try

    [cantidad stock medida]) +0

     

    Also it is more successful when Row and Column (columns) are coming from dimension table

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak  thanks for the answer!. It´s not working...the result is still blank...I tried with measure and calculated column...I think the problem is related to the branch...the blanks are because there is no value in column 'Talle' for the branchid...I don´t know what to do! ehhehe

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    Please create a new table and the relationship.

     

    Talle = VALUES('curva_integrada'[Talle])

     

    Then use the measure:

     

    Measure = SUM ( curva_integrada[cantidad_stock] ) + 0

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.