Forum Discussion
To display total value from separate column
Hi, I am having values in two forms, actual and target values. In matrix table, listed the various product with actual value and total to be displayed for target value(But, I am getting the total of...
You can create a measure using dax like pattern below:
target = CALCULATE ( SUM ( Table[Values] ), ALLEXCEPT ( Table, Table[Product] ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
The image 1 says, values at different currencies taken from 'Column 1' but total state the value from 'Column 2', not the sum of values from different currencies. Can any one help.