Hello everyone, I’m trying to perform an intersection() between an Enum field and an Enumlist using a slice. However, it only filters correctly in the case where the EnumList has a single option. What I want is a slice for each option of the Enumlis.
Hello there,
Try removing the SPLIT wrapping the EnumList column highlighted here in your expression
EnumList is already a List type, you don’t need to split it, you should be able to intersect it with your Enum column wrapped in the LIST expression.
without Split give INTERSECT takes two arguments of type List…but thanks anyway
Solution from Reddit (MultiTech_Visions) that works
Inside your split, around the list that you’re pulling, you need to wrap a concatenate.
This flattens the list of lists that you’re pulling, into a string, which can then be split using the standard list separator “space comma space”.
IsNotBlank(
lntersect(
List([Tipo Imóvell),
Split(Concatenate(Filtro Leads[Tipo Imóvell]), " , ")
)
)
1 Like