Forum Discussion

Uma_Dhandpani's avatar
Uma_Dhandpani
Helper I
6 years ago

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

Whether the logic is possible

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    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's avatar
      Uma_Dhandpani
      Helper I
      6 years ago

      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.