Data Relationships

[Keshy_10]

Good Day Community, 

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. 

[amitchandak]

@Keshy_10 , You should try to avoid many to many relationship by having a bridge table

https://www.seerinteractive.com/blog/join-many-many-power-bi/

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...