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.
I am trying to add a field called "Benchmark" to the visual below (left).
The "Benchmark" field needs to be separated by Sex as can be seen in the right table (female = 11, male = 11.88).
The final output should be the first left table with "Benchmark" added; when female = 11 and when male 11.88.
When I add the field I have created it expands out the table and creates a series of empty records (i.e. Count of Year with blank values), but gets the benchmark correct.
This is the calculation I am using the calculate the benchmark. It should take the average of performance "Points" where the "Rank" is = 3 and account for Sex.
This is the model schema.
@JFG1234 , Try Measure like
calculate(Average(Table[Points]), filter(allselected(Table) , Table[Rank] = 3 && Table[Sex]=max(Table[Sex])))
Sex isn't in the same table as Points, it is connected by a many:1 relationship through the Athlete_ID as the last picture shows. Is it possible to do through the relationship?
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
35 | |
32 | |
18 | |
18 |