Forum Discussion

Jay20024's avatar
Jay20024
Helper I
5 months ago
Solved

Cost allocation

Hi Folks,   Got a fact table with purchase orders. Each PO is assigned to a product   Purchase orders;Amount;Product #00001;500;TOTO #00002;1500;TOTO #00003;3000;TOTO #00004;5000;TITI   Tot...
  • FBergamaschi's avatar
    FBergamaschi
    5 months ago

    A correction to my previous solution attempt, now all numbers match with what was requested.

    I had overlooked a request on the filtering a single team

     

    File attached and a couple of results here follow

     

     

    If this helped, please consider giving kudos and mark as a solution

    me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

Kedar_Pande's avatar
Kedar_Pande
Super User
5 months ago

Jay20024 

Allocated Cost = 
DIVIDE(
SUM(PurchaseOrders[Amount]),
DISTINCTCOUNT(DimProduct[Team]),
0
)