DAX nth largest value

[dicken]

Hi,
Is there a way of getting the nth largest value using DAX, something like LARGE in excel or list.firstN ( list, count ) {x} ?

Richard

 

[dicken]

Yes, I'm on EU settings, so my ";" is your ",". I usely do think to update it, but not always.
Did you try with MINX?

Just to update had a response from XOR LX and

MINX(
    TOPN( 3, SUMMARIZE( Table1, Table1[Units] ), Table1[Units], DESC ),
    [Units]
)

Works , I'm still working on exaxactly why? DESC , isn't necessary but the use of MINX is.

RD