Forum Discussion

giorgilomidze's avatar
giorgilomidze
Resolver I
8 years ago
Solved

adding several values from table.

Hi. I have water measurers latest values in table and lets say 10 devices. 3 are main measurers. that means that sum of thoes 3 measures should be qual to the sum of other 7 measurers values. there a...
new measure.
sum
values
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi giorgilomidze,

     

    You can create a measure below:

     

    Measure = CALCULATE(SUM(Table1[Device Value]),FILTER(ALL(Table1),'Table1'[Device Level]=MAX(Table1[Device Level])))

     

     

     

    For details, see attached pbix file. 

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi giorgilomidze,

 

Would you please use some dummy data to clarify the 10 measures? Also please explain the expected results. 

 

Best Regards,
Qiuyun Yu 

  • giorgilomidze's avatar
    giorgilomidze
    Resolver I
    8 years ago

    i need measure to show sum of values of first three Devices and measure to show sum of other 7 devices. 

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      8 years ago

      Hi giorgilomidze,

       

      You can create a measure below:

       

      Measure = CALCULATE(SUM(Table1[Device Value]),FILTER(ALL(Table1),'Table1'[Device Level]=MAX(Table1[Device Level])))

       

       

       

      For details, see attached pbix file. 

       

      Best Regards,
      Qiuyun Yu