Marco Russo and Alberto Ferrari compare two keywords:
When you begin modelling in DAX, DISTINCT and VALUES often appear interchangeable: both return the list of unique values for a column in the current filter context. In a clean development model, they behave the same, so it is easy to pick one at random – or worse, swap between them without thinking.
However, they are not identical. The subtle difference is crucial in production models that may one day contain invalid relationships or bad data.
Read on to see how each works and how they differ in practice.
Leave a Comment