Max Value of Slicer while multiple Values are selected

[corp_scorp]

Hello there,

i have a Slicer of Monthname where the User can choose more than one Month. i am searching for a Dax- Formula where the Measure returns the Max of the choosen Months.

for example: if MonthName Slicer got Jan, Feb and Mar as selected Values... Mar should be the Result
i tried already a Measure with MonthNumbers but with MonthName the Result is not the Same...

https://www.dropbox.com/s/9nqmwxxw7ezckc1/sample.pbix?dl=0 

[corp_scorp]

@Barthelworks like a charm:)

[Barthel · Accepted solution]

Hey @corp_scorp,

You could try this measure:

Max Month Number of selected Values = 
VAR _max_month_number =
    MAX ( 'Date'[MonthNumber] )
RETURN
    CALCULATE ( 
        SELECTEDVALUE ( 'Date'[MonthName] ),
        'Date'[MonthNumber] = _max_month_number
    )