- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
capture slicer selection
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-16-2018 05:51 AM
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
Solved! Go to Solution.
Accepted Solutions
Re: capture slicer selection
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-18-2018 02:17 AM
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
All Replies
Re: capture slicer selection
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-16-2018 09:02 PM
You may use measure below.
Measure = MINX ( TOPN ( 2, VALUES ( 'price table'[price max] ), 'price table'[price max], DESC ), 'price table'[price max] )
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Re: capture slicer selection
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-17-2018 02:13 AM - edited 10-17-2018 04:05 AM
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.
Re: capture slicer selection
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-18-2018 02:17 AM
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Re: capture slicer selection
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-22-2018 03:26 AM
Perfect, Thanks!