Forum Discussion

PSRai's avatar
PSRai
Helper III
6 years ago
Solved

Combine two measures

I currently have 1 column = socket_id and 2 measures = Energy Used in Period1 and Energy Used, I need to create a NEW COLUMN which is a mix of the two measures, Energy Used in Period1 and Energy Use...
Need Help
  • helassal's avatar
    helassal
    6 years ago

    PSRai 

     

    Sorry I didn't get back to you earlier.

    Please try to wrap the measures by a calculate.

     

    New Measure = 
sumx('Table', if('Table'[Socket_id ] in {550, 639, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 679, 681, 682, 683}, Calculate([EnergyUsedInPeriod1]), Calculate([EnergyUsed])))
helassal's avatar
helassal
Resolver II
6 years ago

PSRai ,

 

I tried to reproduce the error, but it is working ok for me. Please check this sample file.

However, it is possible to have an underlying reason for the circular dependency, in that case, check this thread with a similar problem and how to attepmt to solve it.

Hope this helps.

 

 

PSRai's avatar
PSRai
Helper III
6 years ago

Thanks, Can't seem to get around the circular reference. any other suggestions?

  • helassal's avatar
    helassal
    Resolver II
    6 years ago

    PSRai 

     

    In that case, try creating it as a measure instead of a column. Can you try it like that:

     

    New Measure = 
sumx('Table', if('Table'[Socket_id ] in {550, 639, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 679, 681, 682, 683}, [EnergyUsedInPeriod1], [EnergyUsed]))

     

     

    • PSRai's avatar
      PSRai
      Helper III
      6 years ago

      helassal 

      Unfortuantely it returns the values of [Energy Used in Period1] but I get 0.0000 on [EnergyUsed].

      [Energy Used in Period1], [EnergyUsed]

      If I switch the two around  [EnergyUsed] and [Energy Used in Period1] then I get 0.000 on the [Energy Used in Period1]

       

      • helassal's avatar
        helassal
        Resolver II
        6 years ago

        PSRai 

         

        Sorry I didn't get back to you earlier.

        Please try to wrap the measures by a calculate.

         

        New Measure = 
sumx('Table', if('Table'[Socket_id ] in {550, 639, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 679, 681, 682, 683}, Calculate([EnergyUsedInPeriod1]), Calculate([EnergyUsed])))