Empty values in matrix visual

[Anonymous]

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!

[v-kkf-msft]

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.

[amitchandak]

@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]

@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