Data Relationships

Question

Good Day Community,&nbsp;I am a fairly new user of PowerBI and am finding some difficulty in understanding the relationships between tables. I currently have 2 tables (applications and contracts) I have a many to many relationship with managers names. The problem however when selecting a name in the slicer, I am only getting the number of contracts and currency value. The applications number does not change. This is also happening when selecting options from more than 1 slicer.&nbsp;

amitchandak · Answer

Keshy_10 , You should try to avoid many to many relationship by having a bridge table 
&nbsp;
https://www.seerinteractive.com/blog/join-many-many-power-bi/
&nbsp;
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geMhttps://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

Forum Discussion

Data Relationships

1 Reply

Related content

Relationship

Relationships

Relationship Issue

Creating relationships

PowerBI Relationships