SQLDAXExcelPython
Leaderboard
CALCULATE and filter contextMedium20 points

Segment share within a region

Write a measure that returns each segment's share of [Total Sales] within its region. Remove only the filter on Customers[Segment], and keep the filter on region.

How your answer is tested

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

EVALUATE
SUMMARIZECOLUMNS(
    Customers[Region],
    Customers[Segment],
    "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.