Grain Shifting Calculations in Power BI (The “Repeating Shipping Costs” Problem)

Each row in your table is a transaction, but your table also includes things like shipping fees. While there is a shipping feel listed for each transaction, the number repeats for every row because it actually only makes sense for the order as a whole. Summing up that column would double, triple, and quadruple count the fee resulting in wildly incorrect answers. In this video I’m going to not only walk you through the surprisingly simple way this problem is solved, I’ll also walk you through how to understand the solution and even use DAX to visualize it on the page.

Click here to download the PBIX companion file

Brian Grant

Brian Grant

Brian Grant is a masterful Senior Analytics Consultant by day, and a Power BI legend by night. A passion for Power BI drove him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. Brian is a constant teacher who leads Power BI training sessions, while sharing his wealth of expertise through video and blogging resources.
Share on twitter
Share on facebook
Share on linkedin
Share on email


Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?