Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@Anonymous,
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
@Anonymous,
You may use measure below.
Measure = MINX ( TOPN ( 2, VALUES ( 'price table'[price max] ), 'price table'[price max], DESC ), 'price table'[price max] )
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.
@Anonymous,
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
Perfect, Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |