{"id":1650,"date":"2026-11-17T16:28:13","date_gmt":"2026-11-17T14:28:13","guid":{"rendered":"https:\/\/www.kaarne.fi\/superstore\/?p=1650"},"modified":"2026-11-17T16:28:13","modified_gmt":"2026-11-17T14:28:13","slug":"power-bi-filter-total","status":"publish","type":"post","link":"https:\/\/www.kaarne.fi\/superstore\/articles\/power-bi-filter-total\/","title":{"rendered":"You Clicked One Filter. Why Did the Total Change?"},"content":{"rendered":"<p>A client clicks one channel in the report. The total changes. They ask whether the calculation is broken, and the report builder is not yet sure how to explain it.<\/p>\n<p>The first task is to establish what the selection was intended to include. A changing total can be entirely appropriate, or it can reveal a design that does not match the reader\u2019s question.<\/p>\n<h2>Predict the result before clicking<\/h2>\n<p>In a fictional freelance project, the report shows a small service week split by channel. The builder writes down the expected total for all channels, then the expected result for one channel on one day.<\/p>\n<p>Using a recognisable example makes the interaction easier to inspect. A selected channel should not be judged only by whether the chart looks plausible. Compare the output with the source values for that same scope.<\/p>\n<p>Record which filters are active while checking. A date selection left over from an earlier demonstration can explain a surprising figure without any change to the formula.<\/p>\n<h2>Explain the selected scope in ordinary language<\/h2>\n<p>Power BI measures are evaluated in context, including relevant filters. Microsoft\u2019s model-design guidance describes measures and the role of filtering in report queries. The practical question for this report is simpler: which records should contribute to this number now?<\/p>\n<p>Put that explanation in the measure\u2019s working definition. If a total is deliberately meant to ignore a particular selection, make that intention explicit and test it. Do not change the formula merely to keep a preferred headline number on screen.<\/p>\n<p>The reader should be able to recognise whether they are seeing a whole-business figure or a selected part of the data.<\/p>\n<h2>Check interactions one at a time<\/h2>\n<p>Start from a known report state. Apply one selection, compare the expected result and note what changed. Then clear it before testing the next interaction.<\/p>\n<p>Include a selection that produces no eligible records. Decide how the report should communicate that situation, rather than allowing a blank to be mistaken for a confirmed zero.<\/p>\n<p>For a more complicated model, relationships and measure definitions also need review. Keep the first learning example small enough that you can reconcile the outcome without relying on appearance.<\/p>\n<h2>Make the client part of the check<\/h2>\n<p>Ask the client to explain what they expect when selecting a channel. If they want the overall benchmark to remain visible beside the selection, that is a presentation requirement to discuss, not proof that all changing totals are wrong.<\/p>\n<p>Document the agreed behaviour and the control example. It gives both parties a reference when the report is changed later.<\/p>\n<p>A useful interactive report does more than respond to clicks. It makes the changing scope understandable so the reader can tell which question the number is answering.<\/p>\n<h2>Continue with a related question<\/h2>\n<p>Explore <a href=\"https:\/\/www.kaarne.fi\/superstore\/power-bi-report-validation-handover\/\">Build a Power BI Report You Can Check and Hand Over<\/a>, or read <a href=\"https:\/\/www.kaarne.fi\/superstore\/articles\/power-bi-duplicate-daily-rows\/\">Your Chart Looks Fine. Did the Data Load Twice?<\/a>.<\/p>\n<p>For a written practice option, see <a href=\"https:\/\/www.kaarne.fi\/superstore\/power-bi-with-matze\/\">Power BI with Matze: contents and requirements<\/a>.<\/p>\n<p><a href=\"https:\/\/einfachmitmatze.de\/power-bi-service-dashboard\/#aff=pasi5e9a&amp;cam=superstore-editorial-20261117\" rel=\"sponsored noopener\" target=\"_blank\">Review the provider\u2019s course details<\/a>. Affiliate link: Superstore may earn a commission if you buy.<\/p>\n<p>Technical reference: <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-bi\/guidance\/star-schema\" target=\"_blank\" rel=\"noopener\">Microsoft Learn: Power BI model design<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When a Power BI total changes after a selection, check the selected scope and expected result. Use a small control example before changing the measure.<\/p>\n","protected":false},"author":1,"featured_media":1691,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[35],"tags":[],"class_list":["post-1650","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-digital-tools"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.kaarne.fi\/superstore\/wp-content\/uploads\/sites\/7\/2026\/11\/power-bi-7.webp","_links":{"self":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/comments?post=1650"}],"version-history":[{"count":5,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1650\/revisions"}],"predecessor-version":[{"id":1834,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1650\/revisions\/1834"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/media\/1691"}],"wp:attachment":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/media?parent=1650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/categories?post=1650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/tags?post=1650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}