Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Creating Allocations Based on Multiple Criteria

Hello- I am working on a dashboard that rolls up monthly raw material rate impacts vs. prior month and vs. prior year.  The main data table with the results is made up of raw material codes with their respective reporting categories.  The table also contains all historical monthly versions back to the beginning of the year so I can track cumulative monthly rate impacts throughout the year.  In a second table I have 10 divisions that have assigned allocation percentages based off of the reporting cateogory in a matrix format (divisions along the row 1 of the spreadsheet and reporting categories in column A) that I unpivoted to contain a column for Category, Division and allocations).  I would like to be able to report out on the impact each Division receives of the overall monthly company impact.  For example if in September we were $100k favorable vs. prior month due to decreased rates on flour raw materials, i want to be able to show that Division A receives 20% of the impact from any raw material code categorized as Flour, Division B receives 50% and Division C receives 30% (etc for all raw materials and their categories).  I just need to be able to drill down all the way to the raw material level or be able to view it at the highest level just by division impact to all divisions.  Is this possible to do?  I do have an active relationship between my main data table and the allocations table based off of reporting category.

Super User
Super User

Please provide samples of your data, its really difficult to read so much text that is not even formatted.  Its really simple to show some samples of what your data looks like and then an example of your expected output in line with the data.



If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors