Mesure as a filter

[NicolasF26]

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

[CharbelArmaleh]

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]

HELLO, 

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

[Idrissshatila]

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]

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

[Idrissshatila]

@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]

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

[NicolasF26]

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