Forum Discussion
Allocation by Branches
Hi All, i have a branch table and the columns are; Country, City, Branch Also i have a expense table and the columns are; Date, Branch, Expense type, Amount Also i have a sales table and the col...
Kedar_Pande
Super User
Super UserSumming Expenses by City
Total Expenses by City =
CALCULATE(
SUM(ExpenseTable[Amount]),
ALLEXCEPT(BranchTable, BranchTable[City])
)
Calculate Sales Share for Each Branch
Sales Share by Branch =
DIVIDE(
SUM(SalesTable[Sales Amount]),
CALCULATE(
SUM(SalesTable[Sales Amount]),
ALLEXCEPT(BranchTable, BranchTable[City])
)
)
Allocate Expenses to Branches by Sales Share
Allocated Expenses =
[Sales Share by Branch] * [Total Expenses by City]
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn