Thank your for this video. Fantastic This was precisely the scenario I've been struggling to create using What If parameters to target forecast cost of select Opportunities. Many thanks.
Really good analysis video ! Similar to Trevor Embree I would like to only have the demand increase of all other products on the resellers sales that sell the selected products. I am having real complex totals problems and wondered if you could help ?
based on the setup for this dashboard you created here, do you know if it's possible to adjust multiple product names at different % changes all at the same time? in the video you have here, you're adjusting either individual or group of product with the same %, but I'm wondering how I could apply different %'s to multiple products at the same time.
Hi There! This is extremely useful! However, my company wants to add another layer of complexity, which is to have 2 or 3 different sets of selected Products and adjust their different price increase to see how that impacts the total sales. I am out of tricks here, and was wondering if you could provide any insight for this? Thanks!
Hi Damien, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Hey Sam - useful stuff again - thx! I'm struggling with a 'similar' scenario; less complex in that we don't need the "Demand" option however; on the Product side: we'd like to return the list of currently purchased (subscription) products by a single customer (similar to your list down the left of the report) but have a selectable "level" of discount (similar to your 'Price Change') for every Product on the list. The report will calculate the change in cost to the business and also the increase or decrease in overall cost to the customer. Super bonus if we could have a Quantity selection per listed product also. Any thoughts appreciated :)
Great video! the only thing that im not following is what has the "All Sales" measure that is keeping only the page filter (Year 2016) and not the product filter. Without that explanation its hard to understand the logic for me. I will assumme something in the lines of: All Sales = CALCULATE( [Total Sales], ALL('Product'[Manufacturer]) )
Hello @rodrik90, At the beginning of the video itself, it's showcased onto the report page that, a filter has been applied onto the entire page where "Year = 2016" and therefore, "All Sales" measure is calculating the total sales results for the entire 2016 ignoring the filter on products. Below is the measure provided for the reference that contains the logic for "All Sales" - All Sales = CALCULATE( [Total Sales] , ALL( Products ) ) For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our TH-cam channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/
Hi Staicu, all pbix file/datasets/resource files are available for download in the Enterprise DNA On-Demand platform, which is accessible via a Subscription. Check out the link below. Cheers! Sign up here: app.enterprisedna.co/sign-up
Wouldn't it makes sense that the product that gets a discount also gets an increase in sales? If your top product is given a -20% discount is it not included in the increase in demand with the "Non selected Sales" or is that discounted product still included with the increased bump? Interesting analysis either way. I'd be interested in a top 25% products "What if" analysis. Either "What if" your customers looked like the top 25% average of customers and how much you would gain based off the number of customers... Or "What if" the top 25% price average of products and how much you would gain based off the number of products sold. These what if analysis' are great! Keep up the good work!
Hi Trevor, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
![How To Use Variables In DAX Formula With Power BI [2023 Update]](http://i.ytimg.com/vi/AmhU_isPthc/mqdefault.jpg)
![How To Use Variables In DAX Formula With Power BI [2023 Update]](/img/tr.png)
Check out our FREE courses: bit.ly/3N00AJw
Thank your for this video. Fantastic This was precisely the scenario I've been struggling to create using What If parameters to target forecast cost of select Opportunities. Many thanks.
Sam, great video. I have a Enterprise DNA Pro subscription. Can you point me to where I can find this solution? Thank you
This is great! You could set budgets going forward with forecasting.
Really good analysis video ! Similar to Trevor Embree I would like to only have the demand increase of all other products on the resellers sales that sell the selected products. I am having real complex totals problems and wondered if you could help ?
based on the setup for this dashboard you created here, do you know if it's possible to adjust multiple product names at different % changes all at the same time?
in the video you have here, you're adjusting either individual or group of product with the same %, but I'm wondering how I could apply different %'s to multiple products at the same time.
Hi There! This is extremely useful! However, my company wants to add another layer of complexity, which is to have 2 or 3 different sets of selected Products and adjust their different price increase to see how that impacts the total sales. I am out of tricks here, and was wondering if you could provide any insight for this? Thanks!
I have a similar problem. Did you find the correct answer
Great Video as always Sam. Keep up the fantastic work :)
Hi Damien, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Hey Sam - useful stuff again - thx! I'm struggling with a 'similar' scenario; less complex in that we don't need the "Demand" option however; on the Product side: we'd like to return the list of currently purchased (subscription) products by a single customer (similar to your list down the left of the report) but have a selectable "level" of discount (similar to your 'Price Change') for every Product on the list. The report will calculate the change in cost to the business and also the increase or decrease in overall cost to the customer. Super bonus if we could have a Quantity selection per listed product also. Any thoughts appreciated :)
Great video! the only thing that im not following is what has the "All Sales" measure that is keeping only the page filter (Year 2016) and not the product filter. Without that explanation its hard to understand the logic for me. I will assumme something in the lines of:
All Sales =
CALCULATE(
[Total Sales],
ALL('Product'[Manufacturer])
)
Hello @rodrik90,
At the beginning of the video itself, it's showcased onto the report page that, a filter has been applied onto the entire page where "Year = 2016" and therefore, "All Sales" measure is calculating the total sales results for the entire 2016 ignoring the filter on products. Below is the measure provided for the reference that contains the logic for "All Sales" -
All Sales =
CALCULATE( [Total Sales] ,
ALL( Products ) )
For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out!
If you haven't yet, do subscribe to our TH-cam channel and LinkedIn group to keep posted on the latest data skills and tools updates.
Hoping you find this useful!
Cheers,
Enterprise DNA
forum.enterprisedna.co/
www.youtube.com/@EnterpriseDNA
www.linkedin.com/groups/12004506/
Is the pbix file available in the portal also
Hi. Where I find to download the Pbix file please? Thanks
Hi Staicu, all pbix file/datasets/resource files are available for download in the Enterprise DNA On-Demand platform, which is accessible via a Subscription. Check out the link below. Cheers!
Sign up here: app.enterprisedna.co/sign-up
Great explanation.
What software do you use for recording?
Wouldn't it makes sense that the product that gets a discount also gets an increase in sales? If your top product is given a -20% discount is it not included in the increase in demand with the "Non selected Sales" or is that discounted product still included with the increased bump? Interesting analysis either way.
I'd be interested in a top 25% products "What if" analysis. Either "What if" your customers looked like the top 25% average of customers and how much you would gain based off the number of customers... Or "What if" the top 25% price average of products and how much you would gain based off the number of products sold.
These what if analysis' are great! Keep up the good work!
Hi Trevor, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
the cinstant swallowing annoyed the hell out of me. I am sorry but couldnt get my head away from it.
You're annoyed that a human being is swallowing constantly? That's all you can hear from this very useful video? Humans are so hard to please.