Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
Thanks in advance.
(edits, clarity)
Solved! Go to 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.
@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.
That was a very informative half an hour or so. Thanks!
@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
User | Count |
---|---|
50 | |
24 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
20 |