Forum Discussion
ibuhary
Helper I
Helper IRANKX
Hello there, I have a table with Store ID, Store Name and Sales. I have created a measure to Rank the Store Names based on highest sales. StoreRank = RANKX(ALLSELECTED( 'Table'[Store Name])...
Not in my test data. See pic below
sokg
Solution Supplier
Solution SupplierWhy do you use ALLSELECTED instead of ALL???
Why do you use 'Table'[Store Name] instead of just 'Table'???
so try this
StoreRank = RANKX ( ALL ( Table ), CALCULATE ( SUM ( 'Table'[Sales] ) ),, DESC )
ibuharyHelper I
Helper IIn that case the ranks returned are all 1 for all the stores
- sokg
Not in my test data. See pic below
- ibuhary
Actually I have a larger database, but I cut it short to ask the question.
Is it possible to send it to you to check what I am doing wrong ?
- sokg
Yes, my email is [email protected]. You can send me your .pbix file.
Please check your privacy of your data. I assume you are allowed to do that.