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 ...
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 |