Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello!
I'm trying to brake my bad habit of adding columns to arrive at a desired outcome, and instead create measures when possible.
I believe this is a fairly simple problem, but I cannot solve it: I simply want a MEASURE to rank the dates in the following table visual (you can access the pbix and data file HERE😞
I simply want to add a MEASURE that 'ranks' these in ascending order. I tried to use both COUNTROWS and RANKX, but could not produce the outcome I'm looking for. In the end, I want the measure to be added to the table visual, and populate a value to the right of each date that ranks each respective date.
I think this logic is what I'm after: I want the measure to iterate through the list, and compare each row to the MIN date in the row, and COUNT that row--adding to the count each time that condition is TRUE.
Thanks for the consideration.
Solved! Go to Solution.
Hi @ccakjcrx
Try this MEASURE
Index = RANKX ( ALLSELECTED ( Sheet1[Month Year] ), CALCULATE ( SELECTEDVALUE ( Sheet1[Month Year] ) ), , ASC )
HEY!
Thanks for responding. I probably should have included this in my original post.
This is the outcome I am looking for:
Hi @ccakjcrx,
If you column stored the normal date value, you can try to use below measure to calculate the rank as the index:
Index = COUNTX ( FILTER ( ALL ( Table ), [Month Year] <= MAX ( [Month Year] ) ), [Month Year] )
Regards,
Xiaoxin Sheng
Hey!
Thanks for helping me out.
I applied your measure, but got the 14 for each row--rather than showing 1 for the first row, 2 for the second row, etc. You can download my .pbix file HERE
I want to do this in a MEASURE, but I'm not sure it is possible 😞
Hi @ccakjcrx
Try this MEASURE
Index = RANKX ( ALLSELECTED ( Sheet1[Month Year] ), CALCULATE ( SELECTEDVALUE ( Sheet1[Month Year] ) ), , ASC )
Hi @Zubair_Muhammad ,
I have tried this, but this does gives the desired ranking.
Please refer the image below
Please, let me know your valuable suggestions.
Thank you 🙂
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |