Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it.
Expressions of the form
return a List type data value that contains the values in Column for ALL records in the entire Table.
Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just:
One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like:
SELECT( Table[Column] , Table[Column] = "X" )
The second argument in SELECT(), the “condition”, is evaluated iteratively across every record in the Table, from the context of each individual record. Which is why you can just use
[Column]. So you change to:
SELECT( Table[Column] , [Column] = "X" )
Good suggestion from @MultiTech_Visions:
An additional helpful tip, you can freely replace “Table” with the name of any Slice and expressions work the same way, but only reference records from the Slice instead of the entire Table.