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(Tableau1[CT]),ORDERBY(Tableau1[CT]))
 
and I want to filter another column (Named "Designation"), and get a table with list of values; values that have as a "CT" column occurrence the result of the measure (which in this case is "CT0161").
 
I reckon it's about values format maybe, but I don't find a way to easily use this measure as a filter, as I could do with any other occurrence in other column
 
Thanks for your help
Best
Nicolas
 
Need Help

7 Replies

  • 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 ?

  • CharbelArmaleh's avatar
    CharbelArmaleh
    Icon for Resolver II rankResolver II
    3 years ago

    Hello

     

    A measure cannot be used as a filter, only calculated column can do

     

     

    Did I answered your question? Please mark my post as solution!

     

     

    • NicolasF26's avatar
      NicolasF26
      Regular Visitor
      3 years ago

      HELLO, 

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