Forum Discussion

Spattrell's avatar
Spattrell
New Member
8 years ago
Solved

Dividing Measure Calculation by Column from another table

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 pla...
  • Spattrell's avatar
    Spattrell
    8 years ago

    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.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Spattrell,

 

Could you please tell me if you get the solution?

 

Best Regards,

Dale

Spattrell's avatar
Spattrell
New Member
8 years ago

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.