Forum Discussion

Continued Contributor

5 years ago

Solved

Dynamically Get First , Second, Third Lowest Values?

Hi Experts, I need some dax help to achieve a requirement , can you please share your inputs around this requirement. I have a Multiselect slicer which shows 1 to 10 numbers. Based on numbe...

Need Help

Jihwan_Kim
5 years ago
Hi, itsmebvk
Please check the below picture and the sample pbix file's link down below.

Min Value Measure =
MAXX (
TOPN (
1,
ALLSELECTED ( 'Table'[Value] ),
CALCULATE ( SUM ( 'Table'[Value] ) ), ASC
),
'Table'[Value]
)

Second Min Value Measure =
MAXX (
TOPN (
2,
ALLSELECTED ( 'Table'[Value] ),
CALCULATE ( SUM ( 'Table'[Value] ) ), ASC
),
'Table'[Value]
)

Third Min Value Measure =
MAXX (
TOPN (
3,
ALLSELECTED ( 'Table'[Value] ),
CALCULATE ( SUM ( 'Table'[Value] ) ), ASC
),
'Table'[Value]
)

https://www.dropbox.com/s/7vvkl6hzj8ejv89/itsmebvamsi.pbix?dl=0

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM