Report Portal

The Many Faces of VALUES()

Much like the ALL() function (or I suppose identical to the ALL() function), the VALUES() function returns only distinct values. Against a column of colors { Red, Red, Red, Blue, Red, Red } both VALUES() and ALL() functions will return a table consisting of one column that is { Red, Blue }. The difference between these two functions is that VALUES() works within the original filter context, where ALL() cares not about you or your silly filter context. it only cares about freedom. Freedom from the bounds of filters and the tyranny of. wait, what?

Read more...

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.