Forum Discussion
aalok29
3 years agoRegular Visitor
Prorating Fees to other Disciplines Proportionally
I want to reallocate all the "Unallocated" fees to other Disciplines proportional to their percentage contribution to the total.
For example:
Unallocated Net Fee Total = $350
Architecture % of Total = $1,900 / $2,725 = 69.7%
Hence, new Architecture Net Fee = $1,900 + (69.7% x $350) = $2,144
Similarly, I want to distribute the "Unallocated" Net Fee total to all other Discipline totals.
1 Reply
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216