Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi I am facing one problem while generating ranks based on total requests by date . i am getting different results.
here 2016 june 18 have 48 no of total requests are there .. As per my logic it should be first rank but the rsult is coming reverse.
date_rank=
Rankx(all(table1(Open Date]),table1[Total Requests],,,Dense)
here [total Requests] is a calculated measure logic = count( table1.reqno)
Plese help me how to get the desired ranks...
Hi @ramutd54
Try adding the SORTOrder parameter
date_rank = RANKX ( ALL ( table1[Open Date] ), [Total Requests],, DESC, DENSE )
After applying the above logic i am etting same rank for all dates..
date_rank = RANKX ( ALL ( table1[Open Date] ), [Total Requests],, DESC, DENSE )
Hi @ramutd54
And all this happened just by adding "DESC"???
Could you share your file?
Give this a try
date_rank = RANKX ( ALL ( table1 ), [Total Requests],, DESC, DENSE )
Hi Zubair Mohammad,
after couple of testings finally i have got the desired output. the logic below is
rank_date = rankx(allselected( table1[Open Date]),calculate(count(table1[Req. No.])),,,Dense)
There's no filters in this report. here i have appliced year slicer and also the dats is changing dynamically as expected...
now i want to implement another concept with this result.
i want to filter the ranks based on slicer selection like top 5 ,10,15,20,.....like that.
thanks for your support..
I am going to apply the top 5 10 15 slicer if any issues i will come back to you ...
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |