Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!