Enumlist intercept

Good evening all,

I have a FilterTable which contains a column that is of type Enumlist.
I have a DataTable which contains a column that is of type Enumlist.

I want to create a slice based on having at-least 1 common selection in both Enumlists.

Both are of the same Type. EnumList with a base Type of Ref.

Im not understanding how I would accomplish something like this. especially with intercept. Does not seem to work the same as with a list.

Any help would be appreciated.

Thanks,

Solved Solved
0 11 1,207
1 ACCEPTED SOLUTION

Please try

INTERSECT(SPLIT(Selected Plant Line Settings[Currant Line #], โ€œ,โ€) , [Line #])>0

or

INTERSECT(SPLIT((Selected Plant Line Settings[Currant Line #]) , โ€œ,โ€) , [Line #])>0

View solution in original post

11 REPLIES 11
Top Labels in this Space