In this video, we explore how to use X functions with the Summarize function in DAX to solve complex Power BI problems. Learn how to handle scenarios involving fact tables, granularity, and virtual tables to calculate accurate totals and averages. We dive deep into a real-world example, showing how to filter sales data for large transactions using functions like SUMX and AVERAGEX. Whether you're working with large datasets or just want to improve your DAX skills, this tutorial will help you master advanced calculations in Power BI.

👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt

👍 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 https://prag.works/MITCHELL40 for 40% off On-Demand Learning!

🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

00:00 - Introduction to X Functions and DAX
00:28 - Scenario Overview: Sales Transactions Above a Threshold
01:35 - Filtering for Large Sales Transactions
03:12 - Discussing Fact Table Granularity
05:02 - Identifying Sales Transactions with Multiple Line Items
07:12 - Handling Aggregation at the Transaction Level
08:40 - Creating a Virtual Table with Summarize
09:34 - Using Filter with Summarize
11:13 - Applying SumX for Total Sales
12:35 - Comparing SumX and Traditional Methods
15:38 - Introducing AVERAGEX for Large Orders
17:51 - Final Thoughts and Best Practices with X Functions
19:20 - Conclusion and Takeaways

Let's connect:

✔️Discord: https://prag.works/yt-discord
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]
#PragmaticWorks