Sum by two groups

[yellow_old_5]

Hi everyone , I need help with this issue i have a table visual:

User	level	Salery
A	1	34
B	2	32
B	2	37
C	1	26
C	3	28
C	1	29
D	3	33
E	1	30

 if i remove the level column i want this:

A	34
B	69
C	83
D	33
E	30

 its possible to do it in measure?

[v-chenwuz-msft]

Hi @yellow_old_5 ,

One point of confusion, if you remove the level column, Power BI will automatically calculate the Salery.

If i misunderstood you, please let me know and share your pbix file without sensitive data and expect result.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yellow_old_5]

https://www.dropbox.com/s/qfml0a8lyf45rts/test%20group.pbix?dl=0 
Hi, thank you for your reply, i have add the pbix file, what i want is like ,i want sum the distinct store type.

[v-chenwuz-msft]

Hi @yellow_old_5 ,

Sorry, still don't quite understand what you want the result to look like. Please give what you want the result to look like, hand-drawn is fine.

Best Regards

Community Support Team _ chenwu zhu

[danextian]

Hi @yellow_old_5 ,

Try this measure below which is similar to COUNTIF in Excel:

MyMeasure =
CALCULATE ( SUM ( Table[Salery] ), ALLEXCEPT ( Table, Table[User] ) )
//will return the sum of Salery for each User

[yellow_old_5]

Thank you for your reply but it doesnt work 😞 , i didnt get the result

[danextian]

What would your formula be if you did it in Excel?

[yellow_old_5]

Hi again , I dont have any formula :), i just dont get right value.