Forum Discussion

pbiforum123's avatar
pbiforum123
Icon for Post Patron rankPost Patron
3 years ago

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...
Need Help
VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
3 years ago

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's avatar
pbiforum123
Icon for Post Patron rankPost Patron
3 years ago

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