Sumproduct price x volume incorrect with DAX on summation level, weighted average price needed
I try to calculate revenue over two fact tables per day and per week. The day revenue is correct but in the week revenue all sales volumes are summed up and multieplied with the sum of all prices in the week. Instead, I need a weighted average outcome. In Excel, on aggregated level, it would be something like : sumproduct(price;salesvolume)/sum(salesvolume).
The (simplified) data model looks like the below screenshot.
I would appreciate any help to use a proper DAX formula that calculates correct revenue both on detailed as well as on aggregated level.