Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
So what I am looking at is finding out the highest/best Rank for the 'Social network' and the month which had this best Rank. Just attaching a sample data. The original data runs into a million rows for multiple months. Would want a measure ideally to calculate the measure, so that if I have a slicer to Social network and Gender, it would give me the best rank and for which month and the followers in that best ranked month.
Sample data:
Month | Social Network | Gender | New followers |
Jan-20 | Female | 90 | |
Jan-20 | Female | 87 | |
Jan-20 | Snapchat | Female | 71 |
Jan-20 | Tiktok | Female | 68 |
Jan-20 | Tiktok | Male | 99 |
Jan-20 | Male | 96 | |
Jan-20 | Male | 95 | |
Jan-20 | Snapchat | Male | 81 |
Feb-20 | Snapchat | Female | 69 |
Feb-20 | Female | 46 | |
Feb-20 | Female | 45 | |
Feb-20 | Tiktok | Female | 34 |
Feb-20 | Male | 94 | |
Feb-20 | Male | 83 | |
Feb-20 | Tiktok | Male | 31 |
Feb-20 | Snapchat | Male | 29 |
Mar-20 | Female | 86 | |
Mar-20 | Female | 73 | |
Mar-20 | Tiktok | Female | 55 |
Mar-20 | Snapchat | Female | 26 |
Mar-20 | Male | 93 | |
Mar-20 | Tiktok | Male | 92 |
Mar-20 | Snapchat | Male | 76 |
Mar-20 | Male | 41 |
Excepted result:
Social Network | Gender | Best Rank | Month(Best Rank) | Folowers (best Rnk mth) |
Female | 1 | Mar-20 | 86 | |
Male | 1 | Feb-20 | 94 | |
Female | 1 | Jan-20 | 90 | |
Male | 1 | Mar-20 | 93 | |
Tiktok | Female | 3 | Mar-20 | 55 |
Tiktok | Male | 1 | Jan-20 | 99 |
Snapchat | Female | 1 | Feb-20 | 69 |
Snapchat | Male | 3 | Mar-20 | 76 |
Thanks in advance
Regards,
Nithish
Hey,
Thanks for the replies Greg and Amit.
I am able to figure out the measure for the Rank. The problem is I am not able ascertain the best rank for the social networks and the month(best rank).
Please assist based on the sample data shared.
Thanks.
Regards,
Nithish
@pbininja ,For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
Seems like you need to do a RANKX and then a MINX or MAXX with appropriate filters.
Check out: https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452
and
See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |