Slicer obtain the max value from selected values

[cg1980]

Dear Coleagues, 

I have a table that contains different reporting periods, the period is in a report as an slicer (Fig 2), in a way that the user can see results consolidated or by period, normally its cumulative so you if you are in December , then feb, march, june and sep and dec are likely to be selected, up to here , so far so good.. easy...  the tricky part is that apart of the consolidation i need to also calculate some KPIs based on the lastest period selected,  in the  example below (Fig2) i will have to calculate some KPI in the last selected period December 2020  (i.e # of records)  making the filters is not problem, the problem is how to obtain the MAX Selected value from the items selected on the slicer? , someone will notice that i have the "Order" Column which can be used to retrive the max , que question is how to obtain the max from the list of selected items on the slicer. hope this make sense and i appreciate your help in advance, 

Cristian 

[Anonymous]

Hi @cg1980 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Yuna

[Anonymous · Accepted solution]

Hi @cg1980 ,

Do you want to get the maximum value of the selected value in the slicer?

If so, you can create a measure as follows.

Measure 2 = MAXX(ALLSELECTED(Sheet2[period]),[period])

Best Regards,

Yuna

[amitchandak]

@cg1980 , Assume this coming from date table where you have date too or YYYYMM will work in both case.

You can get max month like

measure =
var _max = maxx(allselected('Date'),'Date'[Date])
return
maxx(filter('Date', 'Date'[Date] = _max), [Period, Text])

You can move return to var and use that in filter