Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
@navneet0512 , what is the issue?
It always better to have rank with explicit column and with a measure
m1 = CALCULATE(DISTINCTCOUNT('Query1'[OrderNumber]))
Serial No = RANKX(ALLSELECTED('Query1'[SPAC]'Query1'[SpanFacility], 'Query1'[Transport mode], 'Query1'[Serial no],'Query1'[Postal Code]),[M1],, DESC, Dense)
or create a visual calculation
Serial No = RANKX(ROWS,[M1],, DESC, Dense)
Next-Level Power BI Visual Calculations with Offset, Index, Rank, RowNumber, And Rankx:https://medium.com/microsoft-power-bi/next-level-power-bi-visual-calculations-with-offset-index-rank...
@amitchandak Still facing below issues:-
First Step:-
Hi,
Thanks for the solution @amitchandak provided, and i want to offer some more information for user to refer to.
hello @navneet0512 , based on your description, you can refer to the following sample
Sample data
Create the rank measure
Measure = RANKX(ALLSELECTED('Table'[Product]),CALCULATE(DISTINCTCOUNT('Table'[IDNumber])),,ASC)
Output
You need to select the column you want to rank, in this case , i want to rank the product column, so in measure i use allselected(table[product]).
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |