Forum Discussion

NicolasF26's avatar
NicolasF26
Regular Visitor
3 years ago

Mesure as a filter

Hello Everyone,   I can't manage to use a measure as a classic filter for a visual. I use this measure to find the first unique value in the column named "CT"   FIRST_CT = INDEX(1,DISTINCT(Tabl...
Need Help
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

Hello NicolasF26 ,

 

If you want to use it as a filter, you should make it as a calculated column and then put this column in the slicer.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

  • NicolasF26's avatar
    NicolasF26
    Regular Visitor
    3 years ago

    Thank Idrissshatila for you reply, why do I have to make a calculated column, to create an dynamique Index ?

  • NicolasF26's avatar
    NicolasF26
    Regular Visitor
    3 years ago

    Could it be done by a LOOKUP Dax but to obtain a list of values instead of the first one ?

    • Idrissshatila's avatar
      Idrissshatila
      Icon for Super User rankSuper User
      3 years ago

      NicolasF26 
      No, it should be a calculated column so you could view it.

       

      If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

      Follow me on Linkedin

      • NicolasF26's avatar
        NicolasF26
        Regular Visitor
        3 years ago

        Okay but I don't understand what the column should calculate to be able to refer to the first occurance filtred