Forum Discussion
Purchase Allocation Ratio
Hello, I am working on a measure that will allow my company to capture purchase data. The tricky part that we are running into is that some items have cost items that are allocated to multiple it...
mahoneypat
Microsoft Employee
Microsoft EmployeeExample data would help give a more detailed response, but would the following approach work:
1. Make a matrix visual with ProductID as rows and Component ID as columns
2. Make a measure is a countrows of Table 1, or a sum of the cost column
3. Make a measure that give you the % of Total All Products = [Measure from #2]/Calculate([Measure from #2], All(Table1[ProductID]))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat