SQLDAXExcelPython
Leaderboard
Interview classicsEasy10 points

Fix a measure that repeats the same total

The measure in the editor shows the same total on every row. Change it so each category shows its own sales.

How your answer is tested

Your code becomes a measure named [Answer] and runs in this query:

EVALUATE
SUMMARIZECOLUMNS(
    Products[Category],
    "Answer", [Answer]
)
Show solutionLifetime

Runs in your browser. The open-source dax-sql compiler turns DAX into SQL, so this isn't Microsoft's engine. The questions here were checked against Power BI Desktop, but free-form queries can occasionally differ.

DAX measure
Loading editor…

Press Ctrl+Enter or Run to see the result here.