Having trouble with the ANY() function.
ANY(Table[Column]) does not seem to be returning a random value, but the first value in the list every time. Same thing with ANY(SELECT(Table[Column], TRUE)).
Am I reading the documentation wrong? It seems like either of these expressions should return a random value from the list.