i need to create a weighted average measure for the following scenario:
I have 3 SKU on stock with a stock reach of 10 days each (Col: Stock reach per Qty).
They all have 5 quantities on stock (Col: Average Qty on stock).
But they have different volume (Col: Volume per stock unit).
Now i want to weight the total stock reach of the quantities with the volume. To illustrate i created the two Helping Columns where i calculate what i need for the weighted average. The result is the Col: Total Days Stock reach weighted. This column i want to create with a measure. But without the helping columns since i dont want to create them in the Power BI Model. Here the example: