Welcome to Day 3 of the 21-Day Power BI DAX Challenge by Pavan Lalwani!

In this challenge, we solve a real-world scenario using DAX:
"Which product gave the biggest average discount?"

Haven’t joined the challenge yet?
Enroll now to access datasets, daily problems & a bonus gift:
https://learn.pavanlalwani.com/s/pages/21-days-dax-challenge

In this video, you’ll learn:
1. How to use AVERAGE with CALCULATE
2. Build a virtual table using TOPN
3. Apply SELECTEDVALUE to extract a single result
4. Sort by descending to find highest discount
5. Display the final output using a card visual

This step-by-step example shows how to apply DAX to real analytics problems.

Perfect for Power BI beginners and anyone ready to grow with hands-on practice!

Don’t miss the Challenge 4 Question at the end!

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

Timestamps:
0:08 – Challenge 3: Biggest Average Discount
0:15 – Comparing with Challenge 2 logic
0:29 – Understanding the dataset
0:38 – Creating dummy table with TOPN
0:51 – Using CALCULATE + AVERAGE
1:30 – Converting sum to average in table
1:59 – Getting a single value using SELECTEDVALUE
2:44 – Creating virtual table logic
3:20 – Final output: product with highest avg discount
3:24 – Challenge 4 Question: category with most products


#powerbi , #daxchallenge , #learnwithpavan, #pavanlalwani , #powerbichallenge, #powerbiforbeginners , #daxtutorial , #businessintelligence, #DAXPractice, #powerbitraining , #PowerBIProjects, #learnpowerbi, #dashboardbuilding , #analyticschallenge