cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: adding several values from table.

Hi @giorgilomidze,

 

You can create a measure below:

 

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

 

q6.PNG

 

 

For details, see attached pbix file. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Moderator v-qiuyu-msft
Moderator

Re: adding several values from table.

Hi @giorgilomidze,

 

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

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: adding several values from table.

Dummy example.PNGi need measure to show sum of values of first three Devices and measure to show sum of other 7 devices. 

Moderator v-qiuyu-msft
Moderator

Re: adding several values from table.

Hi @giorgilomidze,

 

You can create a measure below:

 

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

 

q6.PNG

 

 

For details, see attached pbix file. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.