Validating Copilot DAX drafts
Regional managers want a measure that shows the average number of units per
sale in SM_RetailSales. The analytics team asked Copilot to draft it in DAX
query view:
Avg Units per Sale =
VAR TotalUnits = SUM(Sales[Amount])
VAR SaleCount = COUNTROWS(Sales)
RETURN
DIVIDE(TotalUnits, SaleCount)
Sales stores each sale's Quantity (units) and Amount (dollars). The
draft runs without errors. What does comparing the draft's references with
the request reveal?
This exercise is part of the course
Data Ingestion and Semantic Models with Microsoft Fabric
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise