Multiple Relationships

[mdex]

I'm new to PBI and I'm having issues with Active/Inactive relationships and I cannot figure a way around it.  I have 2 tables,

Time Booking

Name	TeamID	Hours	PGLHours	Week_Number
Bob	1	5	5	43
James	2	2	4	43
Gary	1	3	2	43

Report Data

TeamID	Analysts	Hours	Week_Number
1	5	120	43
2	7	200	43

The tables are currently linked via the TeamID. When I'm creating reports from the 2 tables I need to slice using both TeamID and Week_Number. From what I can tell it isn't possible?

[Asac_14 · Accepted solution]

Create two Dim tables one for Unique TeamID and one for Week_Number and connect these two tables to the Dim table. use the Dim table for slicers. Do accept this as solution if this solves your problem.

Thanks & Regards,

KK

[mdex]

Thanks KK