Waterfall: Price-Volume-Mix Analyses with Cost Information

[Anonymous]

Hello everyone,

I would like to create a waterfall charts which shows the LY margin and present margin with the breakdowns such as price, volume and cost. Even though, I created a simple Price-Volume-Mix calculation, I could not add the impact of cost in my work. Is there anyone that can help me creating the DAX measures for the waterfall that I wanted?

[Luca_Yu · Accepted solution]

Hi @Anonymous ,

Because you did not provide the sample data and desired results, so I can only provide solutions according to my understanding. If you want to get more accurate solutions, please provide further details, such as : sample data, desired result screenshots.

My table is:

My measure:

Profit margin =
DIVIDE ( SUM ( 'Table'[Cost] ), SUM ( 'Table'[Price] ) )

Create a waterfall charts:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.