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 -    • Controlling Totals and Subtotals In P...  
Revenue Applied Over Time - https://forum.enterprisedna.co/t/reve...
Download the PBIX File from here - https://forum.enterprisedna.co/t/pbix...

**** 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 To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerBIMatrixTotals #MatrixTotals