Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ambiguous Paths two tables referencing the same

Hi I have two places in my model where this is happening.   I have one table called Suppliers which is just a list of supplier names, and then I have two tables that need to pull data from that tab...
Need Help
Tutorial Requests
Cmcmahan's avatar
Cmcmahan
Icon for Resident Rockstar rankResident Rockstar
7 years ago

In PowerBI you can't enforce both relationships at the same time because there are circular dependencies.  However, when you want to use the non-active relationship in a DAX query, you can use the USERELATIONSHIP function to temporarily use the other relationship 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Cmcmahan thats sheds some light on the situation, however I have to use that with Calculate and what I really want to do is bring Supplier Name into AddOn.. or bring UserName into CBI/Lead... it seems I can only use Calculate with numerical columns.