Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
Thanks KK
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |