Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
86 | |
82 | |
64 | |
49 |
User | Count |
---|---|
124 | |
110 | |
88 | |
68 | |
66 |