Price Volume Cost Mix analysis for Gross Margin!

So excited for this video, hundreds of hours of work are finally coming together!

PVM walk for Revenue has been one of the most popular topics on this blog. Now we have finally figured out how to create a perfect Power BI DAX calculation for PVM or I guess PVCM analysis for Gross Margin. It foots perfectly across any hierarchy, be it a customer, product, or geography - at any level everything will total exactly and consistently to what it needs to be to give you insight into your profitability drivers.