Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have an issue.
I have a fact table which contains two persons: The holder of a contract and eventually his/her partner.
They are both linked to a person table dimension...
When I link both to my dimension table with power pivot I can't activate both relationship:
How can I manage that? Do I need to make two versions of the dimension table?
Thanks for answers.
@Anonymous , seem like bi-directional relation or over-model creating loops of two paths and the relationship is inactive. check the model and try to resolve that
if you have a valid inactive then we can use userelationship
User | Count |
---|---|
129 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
63 | |
54 |