Forum Discussion
Ignacioo
1 year agoNew Member
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Mi intención es poder filtrar los años de ingreso de 5 alumnos, donde yo selecciono 2021 con el fin de que se queden los alumnos que tengan ese mismo año osea 3 alumnos y los demás sean filtrad...
SamWiseOwl
Super User
1 year agoFirst to check is this a measure or New table.
If measure you can't return FILTER as that is a table, use New table.
If _Anio holds 3 students you can't use SelectedValue instead use Values() as that can return a column of values.
With values you need CalculateTable instead of Calculate and IN instead of =.
table =
var _anio = CalculateTable( Values('table'[anio_ingresso), Keepfilter(table))
Return
Filter(
all(Table)
,table[column] IN _Anio
)