For this tutorial, I\u2019m going to show how you can fix matrix totals in Power BI, particularly fixing totals and subtotals if the measures you create don\u2019t 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.<\/p>\n

Brian<\/p>\n

Link mentioned in the video:
\nControlling Totals and Subtotals – https:\/\/youtu.be\/1e44Km4KaJg<\/a>
\nRevenue Applied Over Time – https:\/\/forum.enterprisedna.co\/t\/revenue-applied-over-time\/6324?u=sam.mckay<\/a>
\nDownload the PBIX File from here – https:\/\/forum.enterprisedna.co\/t\/pbix-file-for-fixing-matrix-totals-youtube-video\/<\/a><\/p>\n

***** Video Details *****
\n00:00 Introduction
\n02:35 Context of measures
\n05:40 SWITCH ( TRUE()
\n09:32 Debugging
\n10:50 DAX query
\n11:38 Pivot grid<\/p>\n

***** Learning Power BI? *****
\nFREE COURSE – Ultimate Beginners Guide To Power BI – http:\/\/portal.enterprisedna.co\/p\/ultimate-beginners-guide-to-power-bi<\/a>
\nFREE COURSE – Ultimate Beginners Guide To DAX – http:\/\/portal.enterprisedna.co\/p\/ultimate-beginners-guide-to-dax<\/a>
\nFREE – Power BI Resources – http:\/\/enterprisedna.co\/power-bi-resources<\/a>
\nFREE – 60 Page DAX Reference Guide Download – https:\/\/enterprisedna.co\/dax-formula-reference-guide-download\/<\/a>
\nEnterprise DNA Membership – https:\/\/enterprisedna.co\/membership<\/a>
\nEnterprise DNA Online – http:\/\/portal.enterprisedna.co\/<\/a>
\nEnterprise DNA Events – https:\/\/enterprisedna.co\/enterprise-dna-events-page\/<\/a><\/p>\n

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerBIMatrixTotals #MatrixTotals<\/p>\n","protected":false},"excerpt":{"rendered":"

For this tutorial, I\u2019m going to show how you can fix matrix totals in Power BI, particularly fixing totals and subtotals if the measures you create don\u2019t produce the right results originally. I want to tackle this problem as it<\/p>\n","protected":false},"author":1,"featured_media":2522,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[21,137],"tags":[214,146,143,215,216],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2021\/08\/eoT-jPzV3Wk.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-Et","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2509"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=2509"}],"version-history":[{"count":1,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2509\/revisions"}],"predecessor-version":[{"id":2635,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2509\/revisions\/2635"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/2522"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=2509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=2509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=2509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}