Forum Discussion
Solved
Many 2 Many Relationship issue?
In the screenshot below I have filtered out a table based on cono 7 and resident 15379, its giving me different result sets based on each artype values, now I have another table where I have 3 differ...
Anmolgan , You have tried bringing value from other tables and divide with the count. There does not seems to be common table
Tough to tell what is going on here. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But, in general, avoid many-to-many like the plague (or COVID-19). Use bridge tables if you must have them and use the bridge table values in your visuals as the common factor between the two "fact" tables.