max of slicer

[dfs29]

Hello, 

--> I created slicer : 

_slicer = values('Table'[Colonne 1])

--> and measure : 

_Measure = FIND(SELECTEDVALUE('_slicer'[Colonne 1]),MAX('Table'[Colonne 1]),1,0)

--> I have this :

But I would like to have all summer when I selected summer -usa , I mean that : 

Summer - usa 

Summer - europe 

Summer - asia 

in my mesure maybe I have to specify that I want max of same word here it s summer but idk how 

Is anyone have an Idea ? 

Thanks 

[amitchandak]

@dfs29 , if you want to display the rest three, the slicer needs to come from an independent table and then use this measure with a column from your original table

countrows(Table, Containsstring(Table[Colonne 1], left(selectedvalue(slicer[Colonne 1]), selectedvalue(slicer[Colonne 1]), " ") -1) )