Forum Discussion
Solved
ALLSELECTED vs VALUES
Hello everyone, In a simple way of explanation, what is the different between ALLSELECTED and VALUES ? as I understand correctly and going through all the resources, the "ALL....." is for us to ...
It's way more complex than you might ever think. For a full explanation of all the quirks about ALLSELECTED, please refer to this article: The definitive guide to ALLSELECTED - SQLBI
I think how they return the values
Values
This function cannot be used to Return values into a cell or column on a worksheet; rather, you use it as an intermediate function, nested in a formula, to get a list of distinct values that can be counted or used to filter or sum other values.
Allselected
The context of the query without any column and row filters.
Averagex(Values(Table[Col1]), [Measure])
Will take an Average of the measure after it is grouped at Table[Col1]
while
Averagex(allselected(Table[Col1]), [Measure]) is measure value across all selected values of col1
thank you, this has helped me understand how to use these functions. I was always a little confused.