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.
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.
Solved! Go to 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
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
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 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |