Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to use a measure to find "cost of a win" per team in a given season in a baseball data set. The first table is a table on player salary(called Salaries) that gives the Name(of player), YearID, TeamID, and Salary for the given player. The second table is the Team_Statistics table that gives the stats of a team for a year and contains the Wins statistic. These two tables are linked by a created columns called "YearID_TeamID". The relationship is one to many(Team_Statistic->Salaries) as each team per year has multiple player with salaries given.
Tables:
Currently I have the measure: Salary_Year = CALCULATE(SUM(Salaries[Salary]), GROUPBY(Salaries,Salaries[YearID_TeamID]))
I have attempted to divide this measure by Team_Statistics[Wins] but I recieve the error message "a single value for "Wins" cannot be determined'
Any help would be greatly appreciated.
Thank you for your time.
Solved! Go to Solution.
I couldn't get this to work as it kept giving me the error message "a single value for "Wins" cannot be determined". Ultimately I just ended up creating a new column with the formula CostperWin = DIVIDE(Team_Statistics[SalaryperTeam],Team_Statistics[wins]) in the the Team Statistics table which has stats for every team for every year from 2004-2014.
Hi @Spattrell,
Could you please tell me if you get the solution?
Best Regards,
Dale
I couldn't get this to work as it kept giving me the error message "a single value for "Wins" cannot be determined". Ultimately I just ended up creating a new column with the formula CostperWin = DIVIDE(Team_Statistics[SalaryperTeam],Team_Statistics[wins]) in the the Team Statistics table which has stats for every team for every year from 2004-2014.
Hi @Spattrell,
Since the [Wins] in the one side, you can try it like below for most of the scenarios.
Measure = [Salary_Year] / sum(Team_Statistics[Wins])
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |