What Is The Difference Between Distinct() And Values() In Dax?

1.	What Is The Difference Between Distinct() And Values() In Dax?
Answer» Both COUNT the distinct values, but VALUES() also counts a POSSIBLE implictit VIRTUAL empty ROW because of non matching values in a child table. This is usually in a dimension table. Both count the distinct values, but VALUES() also counts a possible implictit virtual empty row because of non matching values in a child table. This is usually in a dimension table.

Answer»

Both COUNT the distinct values, but VALUES() also counts a POSSIBLE implictit VIRTUAL empty ROW because of non matching values in a child table. This is usually in a dimension table.

Both count the distinct values, but VALUES() also counts a possible implictit virtual empty row because of non matching values in a child table. This is usually in a dimension table.

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?

What Is The Difference Between Distinct() And Values() In Dax?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment