Trying to calculate survey response rates

[BeaudryL]

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

[BeaudryL]

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!

[sayaliredij · Accepted 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!!