Filter by measure values (Non numeric)

[camilocorralesg]

Hi everybody, I have a measure that based on certain parameters classifies the data into two categories "Cumple" and "No Cumple", this is the measure:

Cumple cuatrimestre Gerentes =

var lucc = IF([Puntos cuatrimestre Gerentes] >= 1500 && [Asesores cumpliendo] >= 8, "Cumple", "No Cumple")

var gerentess = IF([Puntos cuatrimestre Gerentes] >= 1200 && [Asesores cumpliendo] >= 8, "Cumple", "No Cumple")

return

IF(VALUES(Asesores[Gerente / LUC clasificacion]) = "LUC", lucc, gerentess)

And this is how it looks in my table:

What i would like to do is to be able to filter my matrix by this two values using a slicer, I know how to put metric values in a slicer with numeric values but I'm a bit stuck with the logic to do it with qualitative data. Thanks in advance.

[v-rongtiep-msft]

Hi @camilocorralesg ,

Do you want to put the Cumple cuatrimestre Gerentes Measure into the slicer? Now Power BI does not support.

If I have misunderstood your meaning, please provide more details.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.