Is it possible to only capture the values used in the range filter?

[Anonymous]

Hi, 

I'm trying to display only the displyed number in the range filter and I tried using the below formula but it renders all the values that exists between (1 - 375) and (0-52).  (I can use MIN and MAX but it will always be constant for all the values)

How can I capture OR display only the numbers that is entered inside the range box filter ?

IF(ISFILTERED(Table1[alpha]),
" || Length of Stay: " &CONCATENATEX(VALUES(Table1[alpha]), Table1[alpha],", "))
&IF(ISFILTERED(Table1[beta]),
" || Number of Treatment Sessions: " &CONCATENATEX(VALUES(Table1[beta]), Table1[beta],", "))

Side Filters

Also is there any way I can add a description above the range boxes like FROM and TO  ?

Thanks

[v-jayw-msft]

Hi @Anonymous ,

Not sure what you mean "MIN and MAX will always be constant for all the values".

Measure = MIN('Table'[Column1])

Measure 2 = MAX('Table'[Column1])

Can you show more details?

Best Regards,

Jay

[MFelix]

Hi @Anonymous ,

What is the result you need to have when the value is between 1 and 375 returns the current number?

The concatanex is a concatenat of all the values of a table in this case you are picking upt the alpha table of the value you have.

Can you share an expected result image?

[Anonymous]

Thanks for your response. Yes I want the selected numbers in the box range. In this case I need result to be displayed as "1" and "375".  Let me know if this info is enough.