How Does Calculate() Result In Context Transition?

1.	How Does Calculate() Result In Context Transition?
Answer» When in row context it transitions to filter context: the filter on the rows of a specific table propagates through the relationship to the RELATED before the calculation is completed. E.g. CALCULATE(SUM(OtherTable[column]) in a calculated column. It extends or modifies an EXISTING filter context, by adding a filter as its second parameter. CALCULATE() ALWAYS introduces filter context. When in row context it transitions to filter context: the filter on the rows of a specific table propagates through the relationship to the related before the calculation is completed. E.g. CALCULATE(SUM(OtherTable[column]) in a calculated column. It extends or modifies an existing filter context, by adding a filter as its second parameter. CALCULATE() always introduces filter context.

Answer»

When in row context it transitions to filter context: the filter on the rows of a specific table propagates through the relationship to the RELATED before the calculation is completed.

E.g. CALCULATE(SUM(OtherTable[column]) in a calculated column.

It extends or modifies an EXISTING filter context, by adding a filter as its second parameter.

CALCULATE() ALWAYS introduces filter context.

When in row context it transitions to filter context: the filter on the rows of a specific table propagates through the relationship to the related before the calculation is completed.

E.g. CALCULATE(SUM(OtherTable[column]) in a calculated column.

It extends or modifies an existing filter context, by adding a filter as its second parameter.

CALCULATE() always introduces filter context.

Discussion

No Comment Found

Related InterviewSolutions

Dax Nested Functions Is Equivalent To Sql What?
What Is The Difference Between Having A Measure As A Second Filter Param And Having The Original Measure Expression As A Param. Filter(table, [measure]) Vs Filter(table, Sum(...))?
Why Don't You Use A Calculate() In The Aggregation Expression Of A Summarizecolumn()?
What Is The Initial Filter Context?
How Does Summarizecolumns Relate To Filtering?
How Can You Propagate Row Context Through Relationships?
How Are Filter Contexts Created?
How Are Row Contexts Created?
What Is The Difference Between Max And Maxa Functions In Dax?
How Does Calculate() Result In Context Transition?