Many 2 Many Relationship issue?

[Anmolgan]

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 different artype with various other values involved. For example when I build my table with resident name and resno and amount, I want to see specific amount for that resident and also amount from 2nd table that false into LIA visual (Below table shows filtered out details of my master table)

Now when I have another table that contains below artype as LIA and certain values attached to it as well:

Now my problem here resides, is how can I build a table where I can see both the artypes and amounts assigned to there respective artypes with respect to there company numbers, resident numbers, date etc. I tried using distinct artypes, but that is not giving me usual results because eventually I have more artypes that has been shown in the images if we talk about all the residences, so building distinct tables and using it with the above 2nd table is giving the below error to me not sure why, I think that is related to both the above tables not having distinct artypes not sure if I am correct there, if anyone can suggest some ways to achive this then it will be great, I can happily join over skype call to show what I am dealing with, as the dataset is huge and I am not sure if I can share that with anyone.

[v-easonf-msft]

Hi , @Anmolgan 

I guess the issue you occurred should be related to the blog below, you may  refer to the blog for solution.

https://prologika.com/determining-power-bi-relationships/

You  can  also refer  to some related post for help.

https://community.powerbi.com/t5/Desktop/Power-BI-Relationship-3-Tables/m-p/898586

https://community.powerbi.com/t5/Desktop/Can-t-display-the-data-because-Power-B-cannot-determine-the...

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Including-a-measure-in-a-visual-creates-a-cro...

Best Regards,
Community Support Team _ Eason

[Anmolgan]

@amitchandak hi, thanks for your help on the call, basically we are stuck in the last operation and need your assitance on it, before 5PM, let me if we can connect before that, much appreciated your efforts.

[Anmolgan]

Hi @amitchandak thanks for all your help its nice to learn from someone who is really an expert on the PowerBi field. The activities that we did today helped in valdating most of the datasets, we just need 1 more help on your end, basically we need to calculate variance on all those columns that we have built but the problem we are facing right now is since we have all our measures divided on the different tables, our calculations is some how messing things up, do let me know if we can schedule another session today I think 30minutes will be good so that we can knock this one out.

Again, I appreciate all your efforts that you have provided on multiple issues.

Looking forward on your response.

[amitchandak · Accepted solution]

@Anmolgan , You have tried bringing value from other tables and divide with the count. There does not seems to be common table

[Greg_Deckler]

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.