Forum Discussion

Raph's avatar
Raph
Helper III
5 years ago
Solved

Use a dynamic distribution key

Hello   I would like to know how to build a chart where non allocated costs will be moved to countries based on their turnover weight. For example I have this :  Name Amount Analytic Reve...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi Raph 

    See the attached file for a possible solution.

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

  • AlB's avatar
    AlB
    5 years ago

    Raph 

    In fact, here is a simpler version without the auxiliary table. See the attached file

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

Raph's avatar
Raph
Helper III
5 years ago

Hello AlB 

Thank you very much for your second solution, unfortunately I think my example was a little too simple compared to the reality and I can't apply your solution on my dataset. I made a PBIX with something closer to my data and the expected result. It would be nice if you could have a look on this.

 

https://drive.google.com/file/d/1GRWKyi3ZpaPrDElfJ3unfK9-kzJW5AiM/view?usp=sharing

 

Thank you!

 

Kind regards

Raphaël