How To Fix Matrix Totals In Power BI

For this tutorial, I’m going to show how you can fix matrix totals in Power BI, particularly fixing totals and subtotals if the measures you create don’t produce the right results originally. I want to tackle this problem as it occurs fairly often in different forms, and addressing the context of a matrix is probably the most difficult of the broken totals problem. This is going to be some sort of a sequel to my previous video discussing about how to control totals and subtotals. Brian Link mentioned in the video: Controlling Totals and Subtotals - Revenue Applied Over Time - Download the PBIX File from here - ***** Video Details ***** 00:00 Introduction 02:35 Context of measures 05:40 SWITCH ( TRUE() 09:32 Debugging 10:50 DAX query 11:38 Pivot grid ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide