How to make an inactive relationship to active without any changes in managing relationships.

[Anonymous]

I have 2 tables.
1. Inventory 
2.UL

There are inactive relationships between them.
I can't make it active. Because data is complicated.
There is one primary key column between them.

Now I want to add columns from these two tables in one table visual.But getting problem because of relationship.
How to solve it?

[Anonymous]

@Greg_Deckler
Can you help with this?

[Idrissshatila]

Hello @Anonymous ,

you can try using the dax function called userelatioship.

check it out https://dax.guide/userelationship/

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Anonymous]

The function returns no value; the function only enables the indicated relationship for the duration of the calculation.
I want to add two columns from table b to Table a in one table visual.