Forum Discussion
RANKX with slicer
Hi PBI community I’ve created a RANKX measure that provides the ranking of a particular client based on the number of enhancements requests they have raised. I’ve played around with multiple ...
Hi - thanks for the suggestions. Unfortuantely same issue (also if i apply skip instead of dense)
amitchandak
Super User
Super Userpbi_challenger ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi - thanks for looking into this. I have a flat data structure with a +10k rows. If an idea would benefit multiple clients then that would show up across multiple rows as below.
I've created this measure to get the unique count per client:
# Ideas = IF(ISBLANK(DISTINCTCOUNT(Ideas[Idea reference])),0,DISTINCTCOUNT(Ideas[Idea reference]))I also have some client descriptive fields that i'm applying slicers on - eg. generate a rank based on Client size = L,XL
Table name = 'Ideas'
Idea reference Client name Client Industry Client Size Idea-1 Client A Industry A XL Idea-1 Client B Industry B L Idea-1 Client D Industry D S Idea-2 Client A Industry A XL Idea-2 Client C Industry C M Idea-3 Client A Industry A XL Idea-4 Client A Industry A XL Idea-4 Client B Industry B L Idea-4 Client C Industry C M Idea-4 Client D Industry D S Idea-5 Client A Industry A XL Idea-6 Client B Industry B L Idea-7 Client A Industry A XL Idea-8 Client B Industry B L Idea-9 Client B Industry B L Idea-10 Client D Industry D S Idea-11 Client A Industry A XL Idea-12 Client A Industry A XL Idea-13 Client B Industry B L Idea-14 Client D Industry D S Idea-15 Client A Industry A XL