Filter by measure values (Non numeric)

camilocorralesg — Tue, 27 Sep 2022 13:05:50 GMT

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.

Re: Filter by measure values (Non numeric)

Anonymous — Wed, 28 Sep 2022 05:52:03 GMT

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.

topic Filter by measure values (Non numeric) in DAX Commands and Tips

Filter by measure values (Non numeric)

Re: Filter by measure values (Non numeric)