I hope that you are all well and safe during this pandemic.
I have modeled a sensitivity analysis on Power BI and i created a measure to forecast prices based on units sold.
I created what if parameters in my model, and then wrote a nested if statement based on the parameters to try forecast projected revenue. Please see attached snippet of my measure.
The data set i am working on is quite big, and the measure seems to calculating correctly and providing me with the desired output. Instead of providing a column total, the measure works on a row context and applies the measure to the other column totals.
I tried creating another measure to run the Total, but it grossly inflates the total. Please see attached Total Measure i wrote.
Is there anyone that can provide guidance on this, as this is the last step i need to do to conclude my model, but I seem to be getting it very wrong.
Thank you in advance.