How to give relationship (join) between aggregated Data table and Detailed Data table in Power BI

[Optimusprime_25]

Hi Team,

I have two tables aggregated data table and detailed data table.

We have a requirement where we should display aggregated data counts on first page, when user clicks on any particular kpi, then it should redirect to detailed level data page where we should display data in detailed level in table.

The major issue we have is how to give relationship between two tables, on what basis we should join both tables so that we should get accurate data when user clicks on any kpi then it should redirect to detailed level data page and show in details.

Ex: Aggregated Data Table

Ex: Detailed Data Table

[bhanu_gautam]

@Optimusprime_25 , Now you can create new table which contains each unique value , means basically copy and one table remove duplicated insert index like country key 1,2,3 and then use merge and insert that index in original table remove name (country name) if you use this column and create relationship.

Building relationships between tables when both have duplicates (youtube.com), Watch this video 

Accept this as solution if it helps.

[bhanu_gautam]

@Optimusprime_25 , You can use country as in one table it looks like it contains unique value and if not then you can create new table which contains unique value and than create relationship with other two tables which have data

[Optimusprime_25]

@bhanu_gautam  Thanks for your rpompt response.

In Aggregated Data table nothing is uniue, country also gets repeated. For every country there could be multiple Body, Class and Type columns. So, this means Country value will get repeated in multiple rows.

Please let me know if anything is possible.

Thank you.