cancel
Showing results for
Did you mean:
Member

capture slicer selection

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

Re: capture slicer selection

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
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Support Team

Re: capture slicer selection

You may use measure below.

```Measure =
MINX (
TOPN ( 2, VALUES ( 'price table'[price max] ), 'price table'[price max], DESC ),
'price table'[price max]
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

Re: capture slicer selection

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.

Community Support Team

Re: capture slicer selection

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
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Member

Perfect, Thanks!