Difference between DISTINCT and VALUES in DAX

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

I recently got a question about differences between DISTINCT and VALUES in DAX and thanks to Jeffrey Wang I created a simple example to describe the difference. Consider the two tables below: Fact and Dim tables, having a single column with the same name of the table. A relationship exists between Fact[Fact] and Dim[Dim]. This relationship generates a referential integrity violations in table Fact for rows containing C, which doesn't exist in table Dim. In this case, an empty row is virtually inserted into the table Dim and all the rows in Fact that don't have a correspondent member in Dim will point to this blank row. Such a row is the only difference between DISTINCT and VALUES.

Read more...

Tags: dax

 

2007-2015 VidasSoft Systems Inc.