Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Many To Many relation not showing unique data

Hi All, I have two files where one is coming from direct sql query and other one is  a excel file. Power BI automatically creates Many to many relationship but still when i try to create table i get...
Need Help
  • Iamnvt's avatar
    Iamnvt
    7 years ago

    if you are new to Power BI, you shouldn't use Many to Many relationship.

    You can try to turn it to One to Many relationship by creating 2 Dimension tables:

    Table 2 = DISTINCT(UNION(VALUES(Sheet1[MONTH]), VALUES('Sheet1 (2)'[Month])))
    Table = DISTINCT(UNION(VALUES(Sheet1[CL_KEY]), VALUES('Sheet1 (2)'[CL_KEY])))

    then use that 2 tables link to the fact table.

    you can check PBI file here:

    https://1drv.ms/u/s!Aps8poidQa5zk6sL6-1C5BrCmzyRug

Iamnvt's avatar
Iamnvt
Continued Contributor
7 years ago

if you are new to Power BI, you shouldn't use Many to Many relationship.

You can try to turn it to One to Many relationship by creating 2 Dimension tables:

Table 2 = DISTINCT(UNION(VALUES(Sheet1[MONTH]), VALUES('Sheet1 (2)'[Month])))
Table = DISTINCT(UNION(VALUES(Sheet1[CL_KEY]), VALUES('Sheet1 (2)'[CL_KEY])))

then use that 2 tables link to the fact table.

you can check PBI file here:

https://1drv.ms/u/s!Aps8poidQa5zk6sL6-1C5BrCmzyRug