Splitting customer turnover

Question

Dear,I am having difficulty with following:I have customerdata which I would like to attribute to our account managers. Most of the customers have a direct relationship with only one AM, but for some of our (larger) customers, they receive visits from some (if not all) of our AMs.&nbsp;This means that the turnover generated should be attributed based on a weighted score, as we only have a total amount of turnover generated.&nbsp;This is where I am having issues in Power BI, as I can't seem to wrap my head around how start by attributing the weight for those customers, and at the same time have the turnover showing for customers where we only have 1 AM visiting.As you can see in the above uploaded picture, most customers have a weighted score of 1 or 100% whereas some of them have a split, which tallies to 100% as well.&nbsp;Any help would be appreciated.&nbsp;Best regards,Ken

johnt75 · Answer

If you have an Invoices table which includes the income, the customer and the account manager then you could write a measure like&nbsp;
Weighted income =
SUMX (
    Invoices,
    VAR Weight =
        LOOKUPVALUE (
            Customers[Weight],
            Customers[Customer], Invoices[Customer],
            Customers[Account manager], Invoices[Account manager]
        )
    RETURN
        Invoices[Income] * Weight
)

ksoltvedt · Answer

It apears I can get a matrix going now, with everything showing per account and divided per account manager, however the wrong values are showing AND it's always the same value.

So as you can see in the example below the total sales value doesn't match and it repeats for every customer

edit: I resolved the values issues, where it didn't show the same value in the matrix table. I referenced another mapping, which seems to have done the trick.

Only stuck with having the same value for each and every value in the matrix table now.

johnt75 · Answer

that looks like both the customer and the account manager fields are coming from tables which do not filter the invoices table. either that or the measure definition is using ALL or REMOVEFILTERS where it shouldn't