Bottom N

[pbiforum123]

I am using the below DAX to get the Top value, I don't see any function called BOTTOMN to get the last value and also in the below DAX if I use ASC instead then also it is not worrking. Please help me to get the Bottom N.

Measure 5 =
var top1Brand = CALCULATE(TOPN(1,ALLSELECTED(Brand[Brand]),[Summary],DESC))
return
top1Brand

Above DAX gives the brand which ranks 1 but what i need brand which ranks last.

Please let me know if you have any questions.

[pbiforum123]

Hi All,

Any update from anyone on this?

[pbiforum123]

any update from anyone else on this?

[VijayP]

@pbiforum123 

That is my measure which to be filtered by top and bottom values

[VijayP]

@pbiforum123 

if you use ASC , it should work it works for me, try again.

My formula:

Bottom N Branches =

CALCULATE([Selected Item],

TOPN(5,

ALL(Branch[Branch]),[Total Profit],ASC),

DISTINCT(Branch[Branch]))

[pbiforum123]

@VijayP If Selected Item is a measure then what is Total Profit?

[pbiforum123]

@VijayP ok thanks will check and let you know... [Selected Item]??? What is this? I did not understand that to replicate in my pbix.