Get "less than or equal to" value from slicer

[RM_1]

Hi,

Could you please help me with this challenge? I am trying to make a measure, which takes "less than or equal to" value, in this example: 36.82. I tried to use selected value with max function, but it always show max value from column, not the choosen one.

Thanks in advanced,

Rafal

[TeigeGao · Accepted solution]

Hi @RM_1 ,

In your scenario, we can use the following DAX query: 

Measure =
CALCULATE ( MAX ( 'Table'[Column1] ), ALLSELECTED ( 'Table'[Column1] ) )

The result will like below: 

Best Regards,

Teige

[RM_1]

Hi,

I've got one another question regarding this case. I've got one table with 20 columns. Each column refers to one slicer. Is it possible to take different values from different columns by every slicer but from the same table? Right now, using formula: 

Measure = CALCULATE ( MAX ( 'Table'[Column1] ), ALLSELECTED ( 'Table'[Column1] ) )

I only can see the smallest one value, like this:

Thank you,

Rafal

[RM_1]

Thanks, it works properly! 🙂