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
Highlighted
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.

Highlighted
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.
Member

## Re: capture slicer selection

Perfect, Thanks!

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 110 members 1,607 guests
Recent signins: