Grouping Items Together in Power BI Visuals Using DAX Measures

In this tutorial, you'll learn how to use DAX functions in Power BI measures to group multiple items together in your visuals. The functions include the ALL, ALLEXCEPT, ALLSELECTED, and REMOVEFILTERS functions.
👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit prag.works/NICK40 for 40% off On-Demand Learning!
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: prag.works/odl-trial-yt
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: prag.works/yt-twitter
✔️Facebook: prag.works/yt-fb
✔️Instagram: prag.works/yt-insta
✔️LinkedIn: prag.works/yt-li
✔️Discord: prag.works/yt-discord
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#pragmaticworks
00:00 Intro
02:06 Creating a measure for total sales across all items
03:14 Grouping sales by removing filters using the ALL function
04:11 Grouping sales by country using the ALL function
05:55 Grouping sales by group using the ALL function for multiple columns
07:13 Using the ALLSELECTED function for future-proofing and flexibility
08:50 Demonstrating the difference between ALL and ALLSELECTED
10:08 Modifying calculations to respect slicer selections using ALLSELECTED
11:11 Explaining the difference between REMOVEFILTER and ALL functions