DAX to return max of corresponding column based on slicer selection

[smpa01]

Hello experts,

My raw data is following.

Name	Date	Period
Jan	1/1/2019	1
Feb	2/1/2019	2
Mar	3/1/2019	3
Apr	4/1/2019	4

I am passing on the Name as slicer to the users of the report.

What I am hoping for DAX to return is the corresoponding max value of the Period when multiples values are selected from the slicer. For example,

when the selection is following

I am hoping for DAX to return following

[d_gosbell · Accepted solution]

I would expect in this scenario that the simple MAX( column ) would work too

Max Period = MAX('Table'[Period])

[Greg_Deckler]

Probably something along the lines of:

MAXX(ALLSELECTED('Table'),[Period])

[d_gosbell · Accepted solution]

I would expect in this scenario that the simple MAX( column ) would work too

Max Period = MAX('Table'[Period])

[smpa01]

Thanks a lot @d_gosbell and @Greg_Deckler 

[smpa01]

@d_gosbelltested. It did not work. If you have a workbook where it works would be great if you can please upload/share/show.

[d_gosbell]

It works for my single table model (see attached)

[smpa01]

@Greg_Deckler  thanks for the reponse.

So far, I tried this. But did not get what I wanted. Since I am passing the Name to create slicer, ALLSELECTED does not see the corresponding period number in MAXX. SELECTEDVALUE does see the correponding value based on the slicer from the same table but does not allow MAXX to be applied on it.

[Greg_Deckler · Accepted solution]

Seems to work for me, see Page 4 and Table 7 in attached.