CODEWITHSUNDEEP
powerbi
Country girl
Country girl

Reputation: 45

Power BI Indirect Relationship Filter Issue

I have 3 tables: Employee Survey Manager

Employee tbl has direct relationship with both tables, however there is no direct relationship between survey and manager.

I am trying to create a chart/scorecard which does the average score on a question in surgery tbl. This works fine, however I would like to filter this by managers name from manager tbl, and this does not work.

Any help please?

Upvotes: 0

Views: 864

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89006

If you configure a 1-many relationship from Manager to Employee, and a 1-many relationship from Employee to Survey then filters will flow from Manager to Employee to Survey.

Upvotes: 1

Related Questions