Forum Discussion
HMAnnex
2 years agoFrequent Visitor
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
| 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
1 Reply
- _AAndradeResident Rockstar
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-Forum/ba-p/963216