Forum Discussion
Bottom N
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 m...
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]))
VijayP If Selected Item is a measure then what is Total Profit?