Limit column

[Nika3]

Hello!
I have the following question:
How can I restrict data in a column in a table? For example, we have all statuses and only need certain ones that are not closed. I have already tried with if command to exclude the certain statuses, and set close date to 0, but nothing works. Perhaps someone has a tip for me?
I tried this: in the state column, and then show column if:
If([State]= "certain states", [State])
[Completion date]= zero(),
If(([Closing Date]=Null()), [State])

Thanks in advance!

[PrashantSangle]

write set analysis for it

try like

Only({<statuses={'Not Closed'}>}States)

[Nika3]

Unfortunately, that doesn't work either😔