Selecting MIN and MAX values

[WOLFIE]

Hi

I need to display the selected age in my report. I've tried these 2 options, however this always shows only the min and max values from the table. So for example when I select age 14 - 24 and apply many other filters, these numbers will change picking the mi and max value from the table, rather than displaying what the user picked in the filter.

IF(ISFILTERED('Table'[Age]),"| Age: "& MINX(ALLSELECTED('Table'),'Table'[Age]) &" - "& MAXX(ALLSELECTED('Table'),'Table'[Age]) &" ")

IF(ISFILTERED('Table'[Age]),"| Age: "& MIN('Table'[Age]) &" - " & MAX('Table'[Age]) & " ")

[WOLFIE · Accepted solution]

I managed to solve it myself 🙂

VAR MinAge =
    CALCULATE(
        MIN('Table'[Age]),
        ALLSELECTED('Table')
    )
VAR MaxAge =
    CALCULATE(
        MAX('Table'[Age]),
        ALLSELECTED('Table')
    )
RETURN
    IF(
        ISFILTERED('Table'[Age]),
        "| Age: " & MinAge & " - " & MaxAge,
        BLANK()
    )

[_AAndrade]

Hi @WOLFIE,
Could you share a simple pbix with some date so I can take a look?