problem on calculation with with many-to-many related colum

[DavidGolden]

Hello Community, 

I have a dataset with totals sums for different operations, operations refers to differente "Groups".

Groups are RELATED to other table Apport, wich details how each Group is apportioned between individuals (cities). The sum of % for all individuals in each Group adds up to 100%; they are detailed as in the pic below. Relationship is of many-to-many, since each Group appears many times in both tables. 

I need to get Totals for each Individual city, My aproach was to build a meassure in PowerBI typing sumx(Total*related(%)). Despite the relationship seems to be correctly specified (working both ways), It doesn´t work, and I´m getting the message "The column 'Apport[%]' either doesn't exist or doesn't have a relationship to any table available in the current context."

I gues my approach may not be the propper one. Could you help me find a solution, please?

[tamerj1 · Accepted solution]

Hi @DavidGolden 
Please try

NewMeasure =
SUMX (
    Apport,
    VAR CurrentPercent = Apposrt[%]
    VAR TotalGroup =
        SUMX ( RELATEDTABLE ( Group ), Group[Total] )
    RETURN
        TotalGroup * CurrentPercent
)

[DavidGolden]

It´s worth noting that each Individual city appears more than once in the Apport table.