Forum Discussion
Sum question
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 ...
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