Syntax
Tutorial with example
In today’s video we are going to cover the DAX function DISTINCT as well as how DISTINCT compares to VALUES and DISTINCTCOUNT.
Download example file:
Download Power BI file: here.
Remarks
The results of DISTINCT are affected by the current filter context. For example, if you use the formula in the following example to create a measure, the results would change whenever the table was filtered to show only a particular region or a time period.
Let us know your thoughts...