Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi guys, I need help to solve something here.
Red table are fact tables
Green table is a Parent table based on Location table.
OneToMany is represented by arrows.
The problem is Type tables (type parent and Type Location)
If I apply filter on Type Location, i need that the same filter has been applied at Type parent.
I cannot create a join between that because it will be create a circle relationship. I cannot use just one share table because it will create a circle relashionship.
I need to do that because I have two fact tables in different levels, right, however, I would like to apply same filter in both of than.
Could you help me to solve it?
Solved! Go to Solution.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
102 | |
93 | |
69 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
95 |