How to create a relationship in power bi without unique values

by

In this Power BI article, we will see how to create a relationship in Power BI without unique values in Power Bi.

Create a relationship in power bi without unique values

Let us see how we can create a relationship in power bi without unique values in Power Bi.

In this example, I have used the Team Appearances table data, we will create a relationship between two tables (Team A & Team B) and team values. First, we will filter the unique team’s values from the two different tables using Power Bi Dax.

Team A

create a relationship in power bi without unique values example
create a relationship in power bi without unique values example

Team B

Example of create a relationship in power bi without unique values
Example of create a relationship in power bi without unique values
  • Open the Power Bi desktop and use the get data option to load the data into it. In the Model, the section makes the relationship between two columns.
  • Here you can see, the below screenshot displays many-to-many relationships with neither of the team having unique values.
How to create a relationship in power bi without unique values
How to create a relationship in power bi without unique values
  • Now to find the unique values between two tables, create a new table and apply the below-mentioned formula to retrieve unique column values from different tables:
Uniq_Team_Table = 
FILTER (
    DISTINCT (
        UNION (
            VALUES ( 'Team A'[Teams] ),
            VALUES ( 'Team B'[Teams] )
        )
    ),
    'Team A'[Teams] <> BLANK ()
)

Where,

  • Uniq_Team_Table = Table Name
  • Team A, Team B = Existing Table Name
  • Teams = Existing Column names

In the below screenshot, you can see that it displays the unique values from the two different tables.

create a relationship in power bi without unique values
create a relationship in power bi without unique values
  • Now in the Model section, create a relationship for the Teams presented in the Team A and Team B tables with the Unique Team Table.
  • It automatically creates one to one relationship for the Team A( Teams) and Team B( Teams ) values with Unique Team value as highlighted below:
How to create a relationship in power bi without unique values example
How to create a relationship in power bi without unique values example

This is how to create a relationship in power bi without unique values in Power Bi.

This Power BI article is illustrated how to create a relationship in Power BI without unique values in Power Bi.

You may like the following power bi tutorials:

>