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 have page with chart which can be filtered by department, instructor, etc. and I want a card displaying response rate for data in chart (with whatever filters they choose).
example: For instructor = Susan: should be 8 responses/45 enrollment = 18%
what happens: sum(responses)/sum(enrollment) returns 8/175 - it's counting the enrollment for each row in EvalData Table 1
Very new to PowerBi - just can't figure it out 😞
TABLE 1 | |||||
COURSE | DEPARTMENT | INSTRUCTOR | Q | VALUE | RESPONSES |
courseA | MATH | Susan | Q1 | 4 | 1 |
courseA | MATH | Susan | Q2 | 4 | 1 |
courseA | MATH | Susan | Q3 | 3 | 1 |
courseA | MATH | Susan | Q4 | 4 | 1 |
courseA | MATH | Susan | Q5 | 3 | 1 |
courseB | MATH | John | Q1 | 4 | 1 |
courseB | MATH | John | Q2 | 3 | 1 |
courseB | MATH | John | Q3 | 3 | 1 |
courseC | SCIENCE | Susan | Q1 | 3 | 1 |
courseC | SCIENCE | Susan | Q2 | 2 | 1 |
courseC | SCIENCE | Susan | Q3 | 3 | 1 |
TABLE 2 | |
COURSE | Enrollment |
courseA | 20 |
courseB | 18 |
courseC | 25 |
Solved! Go to Solution.
Hi @BeaudryL ,
You can make relationship both direction and it should work
Thanks and Regards,
Sayali
Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!
Proud to be a Super User!
I thought it should be this simple, but kept fighting it - turns out I had an additional field (one of many) that was in both tables that was causing the issue. Got rid of the duplicate field and it worked. It's the little things!
Hi @BeaudryL ,
You can make relationship both direction and it should work
Thanks and Regards,
Sayali
Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!
Proud to be a Super User!
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 |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |