Reply
Highlighted
Member
Posts: 65
Registered: ‎12-01-2017
Accepted Solution

adding several values from table.

[ Edited ]

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.

 


Accepted Solutions
Moderator
Posts: 9,159
Registered: ‎03-06-2016

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.

View solution in original post

Attachment

All Replies
Moderator
Posts: 9,159
Registered: ‎03-06-2016

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.
Member
Posts: 65
Registered: ‎12-01-2017

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
Posts: 9,159
Registered: ‎03-06-2016

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.
Attachment