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

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
5 months ago

Thankyou, Juan-Power-bi, johnt75, FBergamaschi and Kedar_Pande for your responses.

Hi Jay20024,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solutions provided by Juan-Power-bi, johnt75, FBergamaschi and Kedar_Pandeto resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.