Row filter condition

[Cannone_Cannone]

I usually ask for your precious help.
I have this formula in a slicer view IN([Validity], LIST(expired, expiring)) which works great, I would like to add that it doesn't show me the rows with the "Terminated" values present in the "Status" column. How can I change it?

Thanks for all

[Joseph_Seddik · Accepted solution]

AND(
  IN([Validity], LIST("expired", "expiring")), 
  NOT("Terminated" = [Status])
)

[WillowMobileSys · Accepted solution]

Change it to:

AND(
    IN([Validity], LIST(expired, expiring)),
    NOT([Status] = "Terminated"
)

I hope this helps! 

[Joseph_Seddik · Accepted solution]

AND(
  IN([Validity], LIST("expired", "expiring")), 
  NOT("Terminated" = [Status])
)

[WillowMobileSys · Accepted solution]

Change it to:

AND(
    IN([Validity], LIST(expired, expiring)),
    NOT([Status] = "Terminated"
)

I hope this helps! 

[Cannone_Cannone]

Hi, thank you, it works very well, but can it also be applied to a column in another table?
Thanks again

[Joseph_Seddik]

Yes. You just have to provide the row in which that column exists by using a dereference expression or lookup function like ANY(SELECT( ... ))

[Cannone_Cannone]

Thank you but do I have to insert Any select at the beginning of the formula?

[WillowMobileSys]

On the row you are checking Validity, Do you have a reference column to the specific row in that OTHER table?

[Cannone_Cannone]

Hi, could you kindly help me with this formula? A thousand thanks

[Joseph_Seddik · Accepted solution]

It would be:

AND(
  IN([Validity], LIST("expired", "expiring")), 
  NOT("Terminated" = [Employee ID].[Status])
)

[Joseph_Seddik · Accepted solution]

AND(
  IN([Validity], LIST("expired", "expiring")), 
  NOT("Terminated" = [Employee ID].[Status])
)

[Cannone_Cannone]

Thanks a lot Perfect!

[Cannone_Cannone]

Hi, yes the reference column is "Employee ID"