Value distributed to other Dimensions

[Anonymous]

Hello all

I hope you can help me. 🙏

I have a case where I need to compare used time from a fact-table (invoice) with a static estimated time that is located in another table (KIT-tabel).

The estimated time have a dimension called KIT no., which also relates to some of the rows within the fact-tabel, but the used time doesn't have a KIT-dimension (it is blank).

The used time also needs to be recalculated based on the time efficiency of the role of the user.

How can I distribute the recalculated used time on the KIT no. rows based on the KIT no.'s share of the invoices estimated time?

Here are the tables and the last picture is the outcome I hope for:

Can anyone help me on which way to go to solve this?

I have attached a PBIX-file as well, which can be found here: https://we.tl/t-7gPh0uJH5f

Thank you in advance! 😃

[Anonymous]

Hello @Anonymous 

Unable to download the file. Seems like the link/transfer is expired. Could you please share again?
Thank You.