Forum Discussion

ZakJaconelli's avatar
ZakJaconelli
Frequent Visitor
3 years ago
Solved

Creating a filter table to avoid having two onscreen filters - Ambiguous relationship

Hi there,

 

In my current report I'm looking to filter 2 tables using one onscreen filter by introducing a helper table (user account details, and required training) by the same column type (team). The issue I'm getting stuck at is Power BI won't allow an active relationship due to an ambiguous relationship between the Team Filter and Training records. Maybe there is a better way to achieve this, or maybe I've incorrect setup my data model. 

 

I'm sure there's something I'm doing wrong, any help would be greatly appreciated, thanks in advance!

 

Training Records - Fact Table

User account details - Dimension Table

Required Training - Dimension table

Team filter - Helper

 

 

 

Sample Data:

 

User account details:

User IDTeam
1Team 1
2Team 2
3Team 3
4Team 1
5Team 2
6Team 3
7Team 1
8Team 2
9Team 3
9Team 3
8Team 4

 

Training Records 

Training TitleTraining DateUser ID
Course 101/01/20001
Course 202/01/20001
Course 103/01/20002
Course 204/01/20002
Course 104/03/20003
Course 205/03/20003
Course 106/03/20004
Course 207/03/20004
Course 108/03/20004
Course 109/03/20005
Course 110/03/20006
Course 111/03/20007
Course 112/03/20008
Course 113/03/20002
Course 214/03/20004
Course 215/03/20006
Course 216/03/20001
Course 411/03/20003
Course 412/03/20005
Course 313/03/20001
Course 306/03/20008
Course 307/03/20001
Course 308/03/20004

 

Team Filter

Team
Team 1
Team 2
Team 3

 

Required Training

Training TitleRequired By
Course 1Team 1
Course 2Team 1
Course 3Team 1
Course 1Team 2
Course 2Team 2
Course 3Team 2
Course 4Team 2
Course 1Team3
Course 4Team 3

 

Kind regards,

Zak

2 Replies