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...

Icon for Helper IV rank

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