The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have below data and want to RANKX with our grouping , can some one please help me with DAX.
Student Name | PassPercentage |
AbhiRam | 64% |
AbhiRam | 64% |
AbhiRam | 64% |
Adithya Vikram Singh More | 68% |
Adithya Vikram Singh More | 68% |
Adithya Vikram Singh More | 68% |
Aditya | 88% |
Aditya | 88% |
Aditya | 88% |
Thanks,
K Raghavender Rao
Solved! Go to Solution.
Hi,
Found the answer myself. Thanks for your support.
Thanks,
K Raghavender Rao
Column =
RANKX (
'Table',
passpercent, // or average(passpercent)
,
DESC,
DENSE
)
Hi,
Below is the error what i can see.
Thanks,
R
Hi,
Found the answer myself. Thanks for your support.
Thanks,
K Raghavender Rao
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
94 | |
86 | |
69 | |
65 |
User | Count |
---|---|
232 | |
128 | |
116 | |
82 | |
82 |