Forum Discussion

camilocorralesg's avatar
camilocorralesg
Advocate I
3 years ago

Filter by measure values (Non numeric)

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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.