DAX - weighted average per selected amount of days

[Anonymous]

Hello,

I have a data model containing one fact table and two dimension tables.

What I want to calculate is the following table:

So profit can just be a SUM(Profit), but the column weight needs to be a measure. It needs to be the weighted average over the selected days. But as you can see. The Fact table doesn't need to contain data for every day. So the measure needs to keep that in mind.

So the question is, How can I calculate the weighted average per team/teams per selected amount of days?

Thanks in advance!

[Jihwan_Kim · Accepted solution]

https://www.dropbox.com/s/w435mnlx2tnwc6f/rocco.pbix?dl=0