Calculate dynamic measure

[HMAnnex]

Hi Guys, 

I have a matrix of names with different team and I'm trying to create a measure where it will calculate their total score - team score dynamically. 

ATM, this is the measure :

personal_score = [totalscore]-IF(MAX(Teams[Team])="A",[A_Count],[B_Count])

but this is just giving me their score -1

So im basically stuck right now. Thank you.

personal_score = CALCULATE([totalscore]-IF(MAX(Teams[Team])="A",[A_Count],[B_Count]),ALLSELECTED(Teams))

This is giving me all the total score of the team

Name	Team
Tony	a
Connor	a
Steve	b
Jane	b
Anne	a

 

I have a measure where to calculate what is the total team average which is something like:

a= CALCULATE([totalscore], FILTER(Teams,Teams[Team]="A"))+0

b= CALCULATE([totalscore], FILTER(Teams,Teams[Team]="A"))+0

 

[_AAndrade]

Hi @HMAnnex,

Could you please provide more information? For example, some data of your model and the expeted result you are looking for.

Please take a look at this two post how to share data table:
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...