Welcome to Day 5 of the 21-Day Power BI DAX Challenge with Pavan Lalwani!

In this video, we answer a common product analytics question using DAX:
"What is the average unit price of discontinued products?"

Not enrolled yet? Join now to access:
https://learn.pavanlalwani.com/s/pages/21-days-dax-challenge

Daily problem statements
Datasets & submission links
Bonus DAX mini-course

What you’ll learn in this video:
1. Use of AVERAGEX and FILTER in DAX
2. Filtering for discontinued products (TRUE)
3. How to calculate custom average using expressions
4. Difference between implicit and explicit measures
5. Creating logic for both discontinued and active products

This challenge teaches real-world thinking with calculated measures and conditions key for analysts and dashboard developers.

Learn the complete Advanced Power BI DAX Course
https://learn.pavanlalwani.com/courses/Microsoft-Power-BI-DAX-686b9f59bd8e322a4efb3109

Learn the complete Power BI course from scratch:
https://learn.pavanlalwani.com/courses/Power-BI-Specialization-63a05686e4b0a7b1ab4dfc8d

⏱ Timestamps:
0:08 – Welcome to Challenge 5
0:10 – The question: Avg price of discontinued products
0:27 – Understanding the product table
0:39 – Identifying TRUE/FALSE for discontinued items
1:12 – Calculating average using drag-and-drop
1:40 – Now solving using DAX
2:14 – Writing AVERAGEX with FILTER
2:53 – Calculating average on filtered table
3:37 – Validating the result (889)
3:52 – Understanding filters & measures
4:14 – Modifying for continued products
4:31 – Summary of Challenge 5
4:38 – Preview of Challenge 6: % of sales from discontinued products




#PowerBI #DAXChallenge #LearnWithPavan #PavanLalwani #PowerBIChallenge #AVERAGEX #FILTERDAX #PowerBIForBeginners #DiscontinuedProducts #PowerBIProjects #RealWorldDAX #DAXPractice #BusinessAnalytics #LearnPowerBI #DataModeling #PowerBITraining #PowerBIIndia #DataDrivenDecisions #BIUseCase #PowerBIMeasures