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 thin...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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