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.
Hi Geniuses,
All helps are appreciated, currently I am using below DAX formula to rank my salesmen but I want to create a DAX formula where I can rank them category [Channel] wise and I want to use different table/matrix for different channels.
Download my PBI file for better understanding,
https://drive.google.com/file/d/1ruSZf6erk3uoqKgJFe-2rim1ynCPe2vf/view?usp=sharing
SWA Ranking ALL Channel =
Hey @mamunabdullah ,
I didn't fully understand what the result should the look like.
But I think @Greg_Deckler had the right approach. Try the following measure:
SWA Ranking ALL Channel =
RANKX(
ALLSELECTED( 'outlet-report' ),
[Avg Ach of Core & Premium],
,
DESC
)
@mamunabdullah Seems like maybe you could just use ALLSELECTED instead of ALL. This article has some information about RANKX categories, etc. To *Bleep* with RANKX! - Microsoft Power BI Community
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |