Cost allocation to routes under a branch

[zubairs]

I'm creating a cost allocation model where I need to allocate the logistics and sales force cost to routes under a branch.

The allocation is based upon dividing the total cost of the branch with the number of routes under the branch.

The problem occurs when I drop the route into the field. The model is not allocating as per the branch, rather showing the full amount.

Can anybody help?

@amitchandak 

[zubairs]

These are the relationships in the model:

[Ashish_Mathur]

Hi,

Share the download link of your PBI file and also show the expected result very clearly.

[v-easonf-msft]

Hi, @zubairs 

You can add  another measure as below:

measure1 =
CALCULATE (
    [Sales Force(Cost per route)],
    ALLEXCEPT ( 'SAP+BO_salesdata', 'SAP + BO_salesdata'[Route] )
)

Best Regards,
Community Support Team _ Eason