Group column according to TOPN

[rbalza]

Hi PBI Superstars,

Would like to know, how can I group a column according to its TOPN? Probably will need another table. Sample data provided as per below:

https://www.dropbox.com/s/xszrjtxt9oo8k76/sampledata.pbix?dl=0

[Jihwan_Kim · Accepted solution]

Hi, @rbalza 

Please check the link down below.

I created three more measures in the keymeasures table.

I think you already have the group table, so I applied the logic of that group-table.

https://www.dropbox.com/s/2udrs6a0kz66q40/sampledata%20%281%29.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM