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-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-training/customized-enterprise-training/
🔗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: (904) 638-5743
Email: training@pragmaticworks.com
#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
- Grouping Items Together in Power BI Visuals Using DAX Measures ( Download)
- Power BI - GROUP BY without DAX ( Download)
- Grouping and Binning in Power BI ( Download)
- How to set up and use Calculation Groups in DAX | Power BI ( Download)
- Master Grouping and Segmenting in Power BI with DAX: Advanced Tips and Tricks | Measure vs Column ( Download)
- 3 Ways to use Calculation Groups You Need to Know ( Download)
- How to Make Groups in Power BI | Making Custom Categories in Power BI ( Download)
- Power BI - Matrix Visualization - move values from columns to rows ( Download)
- How to Switch Visuals in Power BI with BUTTONS ( Download)
- REDUCE the # of measures with Calculation Groups In Power BI ( Download)
- COMBINE CLUSTERED AND STACKED COLUMN CHART/BAR CHART INTO ONE VISUAL WITH LINE VALUES IN POWER BI ( Download)
- Measures vs. calculated columns in DAX and Power BI ( Download)
- Exploring the SEMANTIC MODEL in Power BI ( Download)
- Concatenate Text Values using Group by in Power Query (w/ Optional Delimiter) ( Download)
- Learn how to group Power Bi Measures from different tables ( Download)
