Desktop

[Gordon2]

Need a dax to capture second higher slicer selection. In my case it is 100:

I know I can get selected value when single selection with:

SELECTEDVALUE('price table'[price max])

But how to get this with multiple ones?

I am gonna use it later to create sales measure to work on ranges selected on slicer

[v-chuncz-msft · Accepted solution]

@Gordon2,

Change it as follows.

Measure =
MAXX (
    FILTER (
        ALLSELECTED ( 'price table'[price max] ),
        'price table'[price max] < MAX ( 'price table'[price max] )
    ),
    'price table'[price max]
)
    + 0

[v-chuncz-msft]

@Gordon2,

You may use measure below.

Measure =
MINX (
    TOPN ( 2, VALUES ( 'price table'[price max] ), 'price table'[price max], DESC ),
    'price table'[price max]
)

[Gordon2]

Thanks Sam,

I think I was not precise in my question. Your measure is working but not in all cases, which I had not mentioned before.

It works on total only.

Sorry for this. I hope you can help further.

How to do a measure to work in a matrix like this?:

An output should show the figures like those on red.

[v-chuncz-msft · Accepted solution]

@Gordon2,

Change it as follows.

Measure =
MAXX (
    FILTER (
        ALLSELECTED ( 'price table'[price max] ),
        'price table'[price max] < MAX ( 'price table'[price max] )
    ),
    'price table'[price max]
)
    + 0

[Gordon2]

Perfect, Thanks!