Max value of slicer

[zsodf]

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

[v-yadongf-msft · Accepted solution]

Hi @zsodf ,

This is my test table:

Please extract [Colonne 1] column in Power Query.

Select  [Colonne 1] column - Add column - Extract  - Text Before Delimiter - enter "-"

You will get a table like this:

Create a slicer:

slicer = SELECTCOLUMNS('Table',"Colonne 1",'Table'[Colonne 1],"Text Before Delimiter",'Table'[Text Before Delimiter])

Create a measure:

Measure = FIND(MAX('Table'[Text Before Delimiter]),SELECTEDVALUE('slicer'[Colonne 1]),1,0)

Put measure into filter pane:

I think this is the result you want:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.