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 are 10 values, one for each device. how can i add thoes 3 and thoes 7 seperately and then compare them.

 

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 

3 Replies

  • 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