How to add same table twice in the model layout?

[yashwanthc]

Howdy BI Users,

I got an unique requirement wherein i have systemusers table which needs to have 2 active relationships (one with opportunity entity & lead entity). Is it possiblke to add systemuser table twice to the model so i could active one active relationship with each opportunity & lead entity for 2 similar systemusers table?

If not, what are my other options to achieve this. Should i create 2 separate reports to get 2 active relationships?

Any other ideas are appreciated!

[camargos88 · Accepted solution]

@yashwanthc ,

You can duplicate or reference the table using power query.

Also you can use the USERELATIONSHIP function to activate an inactive relationship inside a measure.

Using USERELATIONSHIP in DAX - SQLBI

Reference vs Duplicate in Power BI; Power Query Back to Basics - RADACAD