Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Solved! Go to Solution.
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |