Forum Discussion
Ranking data across multiple categories within same column
Zubair_Muhammad wrote:
Could you copy paste sample data or share your file?
Zubair_Muhammad I don't seem to have an option to attach files directly on this forum, so I have uploaded it to file sharing service "filedropper", here is the link: http://www.filedropper.com/data1
Let me know if you need anything else.
Try this MEASURE.
See the attached file as well with your sample data
Measure =
RANKX (
CALCULATETABLE (
Table1,
ALLEXCEPT ( Table1, Table1[ Grouping ], Table1[ Indicator ], Table1[ Year ] )
),
CALCULATE ( SUM ( Table1[ Value ] ) ),
,
DESC,
DENSE
)
Zubair_Muhammad wrote:Try this MEASURE.
See the attached file as well with your sample data
Measure = RANKX ( CALCULATETABLE ( Table1, ALLEXCEPT ( Table1, Table1[ Grouping ], Table1[ Indicator ], Table1[ Year ] ) ), CALCULATE ( SUM ( Table1[ Value ] ) ), , DESC, DENSE )Zubair_Muhammad This is the result for me...it looks like it is ranking correctly according to the value but it is not taking into account Year or Grouping or Indicator. The highest rank should be around 200-300 as that is the max # of countries. Any idea what's going on?
- Could you share file or full data
Zubair_Muhammad Can I send you the file in a private message? If not, I can post here but would rather avoid that.
Thanks,
-Raj