Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |