Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise