Forum Discussion
Solved
Power BI Relationship
Hello Community, I have 2 tables and wanted to build the relationship between these tables as below shown. Could you please help me how to build relationship between them? Table A: Issue-1 I...
Hi HPS1RT
There are several ways to approach this:
- Use the Unpivot option in the Query Editor
- Create two copies of the Table A called Issue 1 and Issue 2
- Make measures using the UseRealtionship() function
First option in the Query Editor choose the issue columns and Unpivot:
Second Option duplicate the tables:
Then join the two tables once with Issue 1 and once with Issue 2:
The third option is to join the same table twice:
Only one relationship can be active at a time, so you need measures to change the active relationship.
All measures using Issue 1 will work as normal, Issue 2 will require each to be a seperate measure.
For example:
Count Issue 1 = Count( 'Table'[Issue])
Count Issue 2 = Calculate( Count( 'Table'[Issue]), UseRelationship('Table B'[Issue], 'Table A Issue 2'[Issue-2]))If this helps please mark as a solution for others to find.
Hello SamWiseOwl ,
Thanks alot for 3rd option.