HOW TO USE SELECT FUNCTION ON A SLICER

[Achiever2023]

I need help with the right expression for below

SELECT(Ticket[category],[created_by]=USEREMAIL())

,ISNOTBLANK([ABC_Comment])

,[status]<>'Completed')

NOTE: I want to display slicer only if the column ABC_Comment is not blank and status is not yet Completed from a Ticket table. Category is also a column in Ticket table

[Markus_Malessa]

Are you saying you are using this in a slice? Or what is 'slicer'? If you are using it in a slice you need to return the key column value vs Ticket[category] unless [category] is your key column.

[Achiever2023]

Here is the screenshot, 

[Markus_Malessa]

You are a bit all over the place here. Does your Tickets table have a [Email] column?

[Achiever2023]

oh sorry, created_by

[Markus_Malessa]

@AleksiAlkio answer should resolve your problem.

[Achiever2023]

yes, thank you for sharing insight too.

[AleksiAlkio · Accepted solution]

The result of the formula needs to be TRUE or FALSE.  To do that, you need to use..

AND([created_by]=USEREMAIL(),ISNOTBLANK([ABC_Comment]),[status]<>'Completed')

[Achiever2023]

Worked!

Thank you