Forum Discussion

Frequent Visitor

5 years ago

DAX Many to Many

I have a two tables with Many-To-Many relationship, Here's the screenshot for two tables Table1: Table2: I need to create measure like this Sum of rate = Sumx(Table1,IF(Table1'Year...

Power BI Dax

NidhiBhusari

Helper IV

5 years ago

Hi Poovarasan try changing the relationship between the two table to Many - To - One.

Poovarasan

Frequent Visitor

5 years ago

Hi, NidhiBhusari

Yeah, I tried but both table ID column has duplicate value when i try to change it Power BI will not accept Many-To-One relationship

Thanks

Poovarasan

NidhiBhusari
Helper IV
5 years ago
Poovarasan Try to create a bridging table between two tables and then set relationship many - to - one.
or can you share sample file? Let me try once
- Poovarasan
  Frequent Visitor
  5 years ago
  Hi, NidhiBhusari
  Yeah, Sure
  Unable to attach file here. I have uploaded in OneDrive.
  Please find pbi file in below link,
  https://swiftant0-my.sharepoint.com/:u:/g/personal/sapowerbi_swiftant_com/EYTINAUftwVPpoYpeM0Ny-8BjwqpjrshcbtoyGfk3E66kQ?e=pymLth
  
  Thanks
  Poovarasan
  - Samarth_18
    Community Champion
    5 years ago
    Hi Poovarasan ,
    Is this the expected output you are looking for, if not then could you please share expected output as well?

Forum Discussion

DAX Many to Many

Related content

Dax with Many to Many

Understanding many to many relationship

many to many

DAX RELATED() with MANY-TO-MANY RELATIONSHIP

Many to Many Measures