adding several values from table.

[giorgilomidze]

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.

[v-qiuyu-msft]

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]

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

[v-qiuyu-msft · Accepted solution]

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