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])))
PSRai's avatar
PSRai
Helper III
6 years ago

unfortunately I get the following error message

 

A circular dependency was detected: readings_true_energy[New Column], readings_true_energy[MaxEnrgy], readings_true_energy[New Column].

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.