Forum Discussion
Ranking Not Working Properly
That is very odd behavior, I can only think that it has something to do with [Product Category] "Fuses" have a sales amount larger than the #2 ranked [Product Line].
However, switching it to to using HASONEVALUE seems to fix it.
Ranking = IF ( HASONEVALUE ( 'Product'[Product Category] ), RANKX ( ALL ( 'Product'[Product Category] ), [Sales Amount] ), IF ( HASONEVALUE ( 'Product'[Product Line] ), RANKX ( All ( 'Product'[Product Line] ), [Sales Amount] ) ) )
Community ChampionHi Anonymous
That looks strange, yes. I don't see anything wrong with your code. In fact, to make it stranger, I was running some tests and realized by chance that by adding another measure to the matrix visual, your measure all of a sudden yields the correct result. If I take my mock measure [Sales rank V3] off the visual, your measure yields the wrong results again. Try it on "Page 2" that I've added to your original file (see attachment). Add and remove [Sales Rank V3] to the visual and see how the result for "Circuit protection" changes between 1 and 2
Maybe knowledgeable people like Zubair_Muhammad, MFelix, Greg_Deckler can have a look and help here
- jdbuchanan71
Super User
That is very odd behavior, I can only think that it has something to do with [Product Category] "Fuses" have a sales amount larger than the #2 ranked [Product Line].
However, switching it to to using HASONEVALUE seems to fix it.
Ranking = IF ( HASONEVALUE ( 'Product'[Product Category] ), RANKX ( ALL ( 'Product'[Product Category] ), [Sales Amount] ), IF ( HASONEVALUE ( 'Product'[Product Line] ), RANKX ( All ( 'Product'[Product Line] ), [Sales Amount] ) ) )