I have a column named Genres (Type Enumlist) at table name Movies.
I want to filter by choosing one of the Genre.
Is it doable?
I had done it with Emum and text but kept failing with Enumlist.
Would you please explain where do you need it and what you have used so far. I assume you are looking for something like..IN(“Classic”,Movies[Genre])
2 Likes
do you mean after choosing column category, the column after showing a subcategory ? if that is your prob so you can use ref with 2 different tables.
1 Like
Is it doable?
Yes.
I had done it with Emum and text but kept failing with Enumlist.
Post a screenshot of the expression that worked successfully with Enum and we can show you what to change to work with EnumList.
1 Like
I used " IN(ANY(SELECT " and it solve.
Thanks all of you for your time.
Hey Bro Steve.
1 Like