Index DISTINCT values

[NicolasF26]

Hello,

I thought my question was an easy question, but I don't get what I doing wrong.

I want to use DAX to find the second (or third, ect...) occurrence in a list of unique values.

So we DISTINCT and INDEX I should be ok but it index all the values and not only the unique one.

In a table called 'Tableau1', I try the obtain the second unique value of a column name 'Tableau1' [CT].

Thanks for your help.

Nicolas

[JohnShepherdAPD · Accepted solution]

Hi Nicolas,

This DAX should do the trick:

SecondDistinct = 
INDEX(2,DISTINCT(DistinctList[List]),ORDERBY(DistinctList[List]))

[NicolasF26]

Thanks a lot John, That was what I was doing but my data were wrong (not the formula), but your help make me find the mistake.

Thanks again

Buy

[Greg_Deckler]

@NicolasF26 See if this helps: The Mythical DAX Index - Microsoft Power BI Community