Power BI Case Study $-$ Question $4/4$

Narrow the Filtered Context of a DAX Measure

The $$Segment $1$ Balance$$ column in the Task $3$ visual is currently displaying the same results as the $$Total Balance$$ column. You

need to update the $$Segment $1$ Balance$$ measure to return the Total Balance for only Segment $1$ in the first row of the Task $3$

table. The other rows in the $$Segment $1$ Balance$$ column should be blank.

Which DAX function can you use as the second argument in CALCULATE$()$ to achieve this task?

SUMX$()$

ALL$()$

ALLEXCEPT$()$

FILTER$()$