Reference Measure Calculation based on Dynamic Selection

[spenceratchison]

Hello,

I am attempting to reference a calculation from a measure within another measure based on a selected value. For example, my goal is to create a measure that subtracts the "Defensive Elo" of one team from the "Offensive Elo" of another team based on selected values. To clarify, if BUF is playing PHI this week in football, I want to be able to select PHI as the home team and BUF as the away team using slicers. Then I would like the measure to return the difference between PHI "Offensive Elo" value and BUF
"Defensive Elo" Value. This would in turn be 1,864 - 1,670.(See Image Below for Reference) I just want this to be a dynamic calculation so that whoever is selected as the Home and Away team it will find the difference between those two values. I hope that makes sense and I appreciate all the suggestions.

[deevaker · Accepted solution]

I think you can create separate tables for home team and away team

and we write measure as

Var a = Calculate(offensive Elo, team=selectedvalue(Hometeam[team]))

Var b = Calculate(Defensive Elo, team=selectedvalue(Awayteam[team]))

Return
a-b