Forum Discussion
Specific data
That is because you are using a Matrix visual.
Question you need to ask here is do you really need to use the Matrix visual for your case? Or using Table visual will also serve your purpose?
If you can use Table visual, then you can easily opt for this option of "Don't Summarize" the values.
But if your option is only the Matrix visual then unfortunatuely, Matrix visual doesn't allow this option. So, in Matrix visual, you can't really have multiple values against one material (in your case 128) What you can do in this scenario is create a measure like this,
Material Value = MAX(Table[Material])Using this measure, you will be able to get the maximum value for your Material (i..e, for Material = 128, it will return max Stock value) but it will ignore all the other values.
Anonymous
i do not have a option for this.
That is because you are using a Matrix visual.
Question you need to ask here is do you really need to use the Matrix visual for your case? Or using Table visual will also serve your purpose?
If you can use Table visual, then you can easily opt for this option of "Don't Summarize" the values.
But if your option is only the Matrix visual then unfortunatuely, Matrix visual doesn't allow this option. So, in Matrix visual, you can't really have multiple values against one material (in your case 128) What you can do in this scenario is create a measure like this,
Material Value = MAX(Table[Material])
Using this measure, you will be able to get the maximum value for your Material (i..e, for Material = 128, it will return max Stock value) but it will ignore all the other values.