Sum question

[SelflearningBi]

I would like to add up value to 26 instead of 52.
the left table is my raw data, the total value is 26 thats what I want as well in my final result display in power bi

the right table is my table after split “data" column and unpivot the columns. then I get the correct quantity, since I would like to calcualte the quantity based on the %, but value, I dont need to multiply %.

Please help, I have been speendding 1 week on this issue..

[lbendlin]

your value is 53, not 52.

To get it back down to the original you need to use the key column (a copy of your original data column) and the quantity.

See attached