Forum Discussion
How to add same table twice in the model layout?
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!
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
1 Reply
- camargos88
Community Champion
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