I apologies if this has been addressed, but I'm banging my head looking for a solution.
I am working on a dynamic Power BI Report that illustrates a chart showing sales discounts across increasing volume sizes.
I have a What-if paremeter that creates a table series of 10-100 at increments of 10. I then want to calculate a weighted average discount for all values 10 - 100 based on measures selected from slicers (also what-if parameters) that define the discounts for increasing increments. For example:
The first 20 units sold have a discount factor of 95%, the next 40 units have a discount factor of 75%, and anything above 60 units has a factor of 50%. The total discount is weighted based on the total units.
I can calcualte the weighted discount for any selected volume level by using multiple measures, but I want to show what the discount is across all volume levels in a line chart to assist a sales team in modeling breakpoints and discount factors.
I can do all of this easly enough in Excel, but I would like to add this functionality to a BI tool for broader publication.
The excel that shows this working is attached. The parameters in the example are excel cells that can be edited, and in my Power BI report they are created from individual what-if parameter tables.
Thank you
xlsl: https://1drv.ms/x/s!Asripv3-9SfJ4S6fRcfHLpxjQOIG?e=HHbbqD
pbix: https://1drv.ms/u/s!Asripv3-9SfJ4S2b9rReLYdDYxkE?e=3icdqE
