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 – https://youtu.be/1e44Km4KaJg
Revenue Applied Over Time – https://forum.enterprisedna.co/t/revenue-applied-over-time/6324?u=sam.mckay
Download the PBIX File from here – https://forum.enterprisedna.co/t/pbix-file-for-fixing-matrix-totals-youtube-video/
***** 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/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerBIMatrixTotals #MatrixTotals