1st column unique text to be used in another column with numbers to be sumed based on the 1st column

[Anonymous]

Okay I got an interesting one that I cannot figure out. 

I thought it woud be easy by just using the IF function, but that did not do it for me. 

Here is what I am trying to do:

I have a column title Teams. Each person in my data is assigned a team. Each team is then associated with a percentage total. That total is in another column. So basically I am trying to sum up specific numbers in one column based on the team text in another column. So for example, one of my teams is Administration. Another column has all scores. I want another column to then take the administration text and apply it to the score column so that the new column adds up the total from the score column based on the Teams column. 

Hopefully that mades sense. If not, here is a visual of what I mean:

thanks! 

[Anonymous]

Hello again, I am wondering if its possible to do this with multiple criteria? I need to also filter it based on Month. So Team and Month. I tried 

Score based On Team = CALCULATE(SUM(Score[TotalScore]),ALLEXCEPT(Score,Score[TEAM],Score[Month])) 

But the month is not filtering in for some reason. The equation does not say there is a any errors. Anyway to get around this? 

Thanks! 

[Shishir22 · Accepted solution]

Hi @Anonymous ,

Please create calculated column as :

Score based On Team = CALCULATE(SUM(Score[TotalScore]),ALLEXCEPT(Score,Score[TEAM]))

I have created table as score smiliar to yours.

If this solves your requirement, please mark it as solution.

Thanks!