What Is The Difference Between Having A Measure As A Second Filter Pa

1.	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(...))?
Answer» A measure has always implicit FILTER context, so the ROW context induced by the FILTER is transferred to filter context in the measure.&LT;br&GT;In case of the expression only, no filter context is imposed on the expression, so the expression is EVALUATED with an empty filter context! This gives a DIFFERENT result. A measure has always implicit filter context, so the ROW context induced by the FILTER is transferred to filter context in the measure.<br>In case of the expression only, no filter context is imposed on the expression, so the expression is evaluated with an empty filter context! This gives a different result.

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(...))?

Answer»

A measure has always implicit FILTER context, so the ROW context induced by the FILTER is transferred to filter context in the measure.&LT;br&GT;In case of the expression only, no filter context is imposed on the expression, so the expression is EVALUATED with an empty filter context! This gives a DIFFERENT result.

A measure has always implicit filter context, so the ROW context induced by the FILTER is transferred to filter context in the measure.<br>In case of the expression only, no filter context is imposed on the expression, so the expression is evaluated with an empty filter context! This gives a different result.

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?