Need RANKX to exclude Blanks
Dear PBI enthusiasts! I am relatively new to PowerBI and struggling through this one scenario. Use case - I have a parameter (type of customer - Domestic / International / Contractors) and depending on what the user chooses, I need to use that as my column. There is a TotalSales calculated DAX which is UnitPrice*Qty. Super simple:) However I need to show only top 5 AND exclude any blanks. I got the Top5 using RankX, but not able to exclude blanks - tried many things, so would greatly apprciate your help. I have attached a sample PBXI file. (Hmm...not sure how to insert the test file...) Thank you in advance! <bottom>