allocation overhead
1 Topic
Overhead Expnese Allocation by Branch
I have sales via branch id and also have a branch id as a headquarter, i want to allocate all the overhead expenses upon sales amounts. so i want to make it in math = ( total overhead for country5 / total sales for country5 ) * sales by branch but when i wrote below DAX code, it doesn't show the allocated expenses across to the branches in the visual table. MeasureAllocationOverheadCN5 = var currentcountryid = SELECTEDVALUE(COUNTRY[COUNTRY_ID]) VAR Totaloverhead = CALCULATE( [Overhead Expenses],BRANCH[BRANCH_ID] = 80) –- headquarter branchid is 80 VAR TotalSalesExcludingHQ = CALCULATE( ( [Total Sales Team A] + [Total Sales Team B] ), COUNTRY[COUNTRY_ID] = 5) –- just want to allocate for country 5 VAR BranchSales = CALCULATE( ( [Total Sales Team A] + [Total Sales Team B] ), COUNTRY[COUNTRY_ID] = 5) VAR AllocationPerBranch = DIVIDE(Toteloverhead, TotalSalesExcludingHQ) * BranchSales RETURN IF( currentcountryid = 5, AllocationPerBranch, BLANK() )Solved697Views0likes2Comments