Forum Discussion
Multiply a matrix value by a sum
Hi everyone. I need a big help with the following question ->
I have certain percertages calculated in a matrix as follows:
Now I want to multiplicate this values by a column that is a sum of values. And those sum values vary accordingly the client.
Can someone help me big please?
Hi, avitoriasrocha
Is what you want to achieve is to multiply the percentage by the percentage of the row total?
Try to create a measure like this:
Measure = MAX('Table'[Value])*CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Product]))Result:
Please refer to the attachment below for details. Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
avitoriasrocha i would suggest you to create a table with multiper values and then you can do the calc in your tables where values will get multipled. You will have to create a calc column or measure that will take value from your multiper table and do the calc for you.
Hi, avitoriasrocha
Is what you want to achieve is to multiply the percentage by the percentage of the row total?
Try to create a measure like this:
Measure = MAX('Table'[Value])*CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Product]))Result:
Please refer to the attachment below for details. Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
