FILTERS() vs VALUES()

[TL5866]

Hi,

DAX has two functions that can be used as filter in CALCULATE: VALUES() and FILTERS().

Would anyone know how they really differ - apart from the fact that VALUES() also takes a table as parameter ? I have done a few tests, but could not spot a difference in results...

[v-sihou-msft · Accepted solution]

@TL5866

They have difference. FILTERS() will directly apply the column as filter into your calculation, which will ingore other filter. But for VALUES(), it just returns a table of single column with distinct values, which means it will take other filter as well. Please see my sample below: 

Measure with VALUES = COUNTROWS(VALUES('Table'[YearMonth]))

Measure with FILTERS = COUNTROWS(FILTERS('Table'[YearMonth]))

Regards,