Advanced Scenario Analysis Techniques For Power BI w/DAX

Review how to run simple and advanced scenario analysis techniques in Power BI. In this example we run through how you can dynamic 'shock' pricing and see how that impacts sales

*****Video Details*****
0:16 - Introduction
2:24 - Total Sales Using SUM vs Total Sales Using SUMX
4:20 - Creating A Supporting Table To Show Price Changes
5:42 - Harvesting The Price Change Percentage Selected
6:56 - Calculating Scenario Sales
7:52 - Showing All Sales Impact Of Selected Products
9:32 - Showing Results Of Selected Products
10:45 - Working Out The Master Calculation
12:37 - Branching Out Into More Measures
12:37 - Branching Out Into More Measures For More Insights
14:44 - Creating Compelling Visualizations To Showcase The Results
16:43 - Conclusion

***** Learning Power BI? *****

***** Related Links *****
Using Multi-Layered Scenario Analysis in Power BI
Scenario Analysis Techniques Using Multiple 'What If' Parameters
Advanced Analytics in Power BI: Layering Multiple 'What If' Analysis

***** Related Course Modules *****
Scenario Analysis Series
Solving Analytical Scenarios w/Power & DAX
Advanced Data Transformations & Modeling

***** Related Support Forums *****
Advice On Data Modeling
Data Modelling?
Multiple Conditions Scenario Analysis
For more data model queries to review see here…..

[EnterpriseDNA]

Related Links
Using Multi-Layered Scenario Analysis in Power BI
Scenario Analysis Techniques Using Multiple 'What If' Parameters
Advanced Analytics in Power BI: Layering Multiple 'What If' Analysis

Related Course Modules
Scenario Analysis Series
Solving Analytical Scenarios w/Power & DAX
Advanced Data Transformations & Modeling

Related Support Forums
Advice On Data Modeling
Data Modelling?
Multiple Conditions Scenario Analysis
For more data model queries to review see here…..

[jazzista]

Mr Sam. Great example. I will have to practice the exercise at least 100 times to understand all the dax measures. That was an excellent explanation as well . Thanks for sharing

[kh]

This is wonderful. So much reporting focuses on the past, but you've given a great example of how a tool like PowerBI can be used to focus on future business outcomes.

[jameshenryhinton]

Amazing technique - wow! I'm trying to imagine how one could apply different scenarios to different products at the same time both from a DAX point of view and avoiding too much clutter to the viz.

[ajaaskelainen]

I really loved how you connected the "pricing scenario" with the rest of the data model by using IF( HasNoValue ( price change %), equal price change %, 0 otherwise)
Also, the calculation of only selected sales: CALCULATE( (all sales), ALLSELECTED ( products))

[thebartlettsystem]

It took me a little while to get my head around it, but this is fantastic. The place I got stuck was on the concept of All Sales - Selected Sales. What I couldn't see at first was that there is a hidden measure of "Unselected Sales." It is the remainder of what is filtered out. That additional measure would have clarified that "off stage" (off filter) sum (which is the difference of no filters minus filters). I point this out because one of the powerful chess moves here is getting at what isn't on the canvas. If you do work with this approach again, it might help slower guys like me make the jump. Fantastic video, though. Your work is amazing.

[mohamedetman]

thank you so much, you know my career path changes to higher level after using Power Bi, DAX, Power Query. thanks again

[miguelnorena]

Great video for learning how to easily create multiple scenarios! Very useful for financial analysis

[udayg]

Thank you very much Sam, great example...keep up the good work...

[luigineri]

Thank you very much for the video. I have one question: in this video, you showed a range of increase percentage (5%, 10%, etc...). Is there a way, in Power BI, in which the user can input the value say: 23.5%?

[georgie]

Thank you for sharing this. This works perfectly!

[monikaselicka]

This is amazing! I have just a question - is it possible to change one product by 5% and another product by 10% at the same time in order to see total changes/increase of sales? Thanks!

[phanindrababa]

Its nice explanation .. But it is very easy in tableau for implementation

[irienoma]

How did you "clone" your middle chart with what seemed to be just a click? Thanks! Very useful videos!

[RH-nkeo]

What's the difference between VALUES and SELECTEDVALUE here for price change?

I can see you test for HASONEVALUE so would it be better to use SELECTEDVALUE in this case or is there no difference between the two?

[npmnpm]

Amazing. Excelent Explanations!!! Subscribed

[marcospapis]

Really, really good! Right on target! Congrats!!!

[thomasdutra]

Excellent video! Keep up with the good work. +1 sub!

[jdj]

Thank you very much for this example - very helpful!
I do have one question while I was trying to use the technique from 9:10 about setting the unchanged [all sales] .

I set my [all sales] using the exact methods from your video. However, my [all sales] kept changing as different products were selected. I wonder which part of my work could be wrong for this?

Thank you for reading my question!

[mohammedsuliman]

Thanks you, great scenario analysis method using power bi