How to get the top 3 and bottom 3 projects for each team scale and display in a Cluster Map?

[almondmilk1]

I have a table with 3 columns: Team Scale(1 to 4), Project, and Total Score. I want to display a Cluster Map for each Team Scale with the top 3 and bottom 3 projects. Can someone help me with detailed steps or share the pbix with me? I tried out using different formulae but didn't get what was expected.

Access to table 

[v-zhangti · Accepted solution]

Hi, @almondmilk1 

You can try the following methods.
Column:

Rank1 = RANKX(FILTER('Table',[Team Scale]=EARLIER('Table'[Team Scale])),[Total Score],,DESC)

Rank2 = RANKX(FILTER('Table',[Team Scale]=EARLIER('Table'[Team Scale])),[Total Score],,ASC)

Measure:

Top3 = IF(MAX('Table'[Rank1])<=3,1)

Bottom3 = IF(MAX('Table'[Rank2])<=3,1,0)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[almondmilk1]

Thank you so much @v-zhangti! This is exactly what I wanted.