To display total value from separate column

[Uma_Dhandpani]

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 actual value)

Whether the logic is possible

[v-yuta-msft]

@Uma_Dhandpani ,

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.

[Uma_Dhandpani]

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.