Forum Discussion

HMAnnex's avatar
HMAnnex
Frequent Visitor
2 years ago

Calculate dynamic measure

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
 
NameTeam
Tonya
Connora
Steveb
Janeb
Annea
 

 

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