Dynamic Scenario Analysis of Average Order Size – Analytics with Power BI

Hi Sam,

Just watched the video on “Dynamic Scenario Analysis of Average Order Size”, particularly for the different way to get a cumulative total, nice one.

Looking at the DAX formula to increase the order size, I am puzzled. It seems that the formula merely adds a selected value (ordersize) to the average sales amount, which I guess is not the intention?

Paul

Enterprise%20DNA%20Expert%20-%20Small

Yes I think it was intentional. It’s obviously not the perfect representation as it’s just an average initially, but I think it produces a fair calculation ultimately that adds some value.

Sam