DAX TOPN function

[dicken]

Hi,

I've been trying to use topn to get the Nth hightest, selling item, I've tried ;

EVALUATE
TOPN(4,VALUES( Table1[Item]) ,[totalUnits] )

and then thought to wrap this in a MINX to get the 4th top Item,,

MINX( TOPN(4,VALUES( Table1[Item]) ,[totalU] ), Table1[Item] )

This does not work, it gives the Min of the items, based on alphabet, So essentially I was trying to get a virtual table of the top 4 values based on Units, and then return the min ie 4th, Item from the ranked Units .

Richard.

 

[RoryA]

Why specify Item rather than totalU as the MINX expression then?

 

[dicken]

Why specify Item rather than totalU as the MINX expression then?

 

[dicken]

I may want to use RANX?
If I use ;

TOPN(4, 
Table1,[Tunits] ,DESC)

I get a four row two column table Item, Units , I was then trying to return the Item associated with the lowest value unit in the returned table. So below ; q.

Richard.

 

[RoryA]

What if there is more than one item with the 4th largest units?

 

[dicken]

What if there is more than one item with the 4th largest units?

No idea, it seems to treat ties the same way they do in golf, I've tried using a rank measure ;

MINX(TOPN( 3, Table1,[Rankm] ), Table1[Item]), but falis for same reason as above.

EVALUATE
TOPN( 3, Table1, [Rankm] ,DESC ) , the Rank measure sorted ASC,

 

[RoryA]

I mean what do you want to happen if there is more than one?

 

[dicken]

I mean what do you want to happen if there is more than one?

I'm not sure, I'm going to have to think about this some more. I find the TOPN function a bit confusing, with the ASC , DESC , which when used with isnonorafter makes sense, and also the 'order by option.

Richard.