RANKX - Top 5 and 'Other'

[NotAHobbyBI]

Hi guys,

Been trying over the weekend to figure out how to simulate a top 5 + others grouping using RANKX. My expectation if to be able to place the Group and a sum into a table to simulate this; Ideally with this sort of ordering. The examples I've found seem to look at ranking within one table, not taking into account the measure is in a different table.

Call Occurance	Country
10,000	USA
5,000	UK
1,000	FINLAND
500	GERMANY
750	OTHER

I have the below structure


RANKX Measure (working as expected)

Country Rank =
RANKX (
ALL SELECTED ( Caller[Country]),
CALCULATE ( DISTINCTCOUNT ('Call Occurance'[Call_ID]))
)

Grouping Measure (Returning nothing)

Country Group = IF(Caller[Country Rank]<=5,"","Other")

 

Thanks in advance.

(edits, clarity)

[SpartaBI · Accepted solution]

@NotAHobbyBI this is not something straighforward in Power BI.
You can achieve it by doing a complex pattern. 
Here is a video that walks you step by step:
https://www.youtube.com/watch?v=nVvlEHKr_0o

Another option is to use custom visuals that supports that natively like Inforiver.

Showcase Report – Contoso By SpartaBI



      

[NotAHobbyBI]

That was a very informative half an hour or so. Thanks!

[SpartaBI]

@NotAHobbyBI my pleasure 🙂
Really recommend to follow them.
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543