Relationship problem after appended data

v-lili6-msft I don't think it's possible to share this data and trying to recreate this mess is an especially daunting task for someone as inept as myself but let me try to explain it once more! I appreciate your patience. 

From my orignial query, I birthed 2 other queries, CCEOI & Net Views. I have filtered both of these queries. Before I added more data, these two queries had a many-to-one relationship using the "Program/Network" column. I was able to have a calucated column between the two queries using other columns in the queries. The forumla for the first column looked like All_Total Viewer Values = DIVIDE (CCEOI [All], RELATED ('Net Views' [All])*100). I was able to use this formula for my other columns and it worked perfectly. 

Now that I have added more data, the relationship between CCEOI & Net Views had to be changed to many-to-many when using the "Program/Network" column. Using the formula you suggested earlier, All_Total Viewer Values = DIVIDE (CCEOI [All], CALCULATE(MAX('Net Views'[All')))*100  the values are incorrect, seeing to be 0.00 or 0.01. These strange values match the output of your other suggestion All_Total Viewer Values = DIVIDE(CCEOI [All], CALCULATE(MAX('Net Views'[All]),FILTER(RELATEDTABLE('Net Views'),'Net Views' [Year]=MAX('Net Views'[Year])))*100 . 

When I match CCEOI & Net Views on a column other than "Program/Network", I can get a one-to-many relationship yet still am not able to reproduce the calculated column I had before.  I have also created another query which is just "Program/Network" in an attempt to connect the queries CCEOI & Net Views that way but no success thus far. 

parry2k So very sorry to bother you but perhaps you can help as well or have some ideas??