How to calculate second lowest premium

[Anonymous]

Hi ,

I have premiums below and want to calculate second lowest premuim .From below example I need to get 2000 has second lowest

premium.

Premium

5000

4000

30000

2000

1000

Pleasehelp on this asap.

[Ahmedx]

or

Measure = 
VAR _MinAll = MINX(ALLSELECTED('Table'[Premium]),[Premium])
RETURN
CALCULATE(MIN('Table'[Premium]),FILTER(ALL('Table'),'Table'[Premium]>_MinAll))

[Anonymous]

Premium

5000

4000

30000

2000

1000

1000

Need to get second lowest from above table as 2000

[Ahmedx · Accepted solution]

pls try

Measure = 
VAR _MinAll = MINX(ALLSELECTED('Table'[Premium]),[Premium])
RETURN
CALCULATE(MIN('Table'[Premium]),FILTER(ALL('Table'),'Table'[Premium]>_MinAll))
-----
Measure = MAXX(
TOPN(2,VALUES('Table'[Premium]),'Table'[Premium],ASC),'Table'[Premium])

[Ahmedx]

pls try this