Forum Discussion
Solved
Rankx with two subcategories
Hello guys, can someone tell what is wrong here? Rankx with 2 categories = CALCULATE(RANKX(ALL(a_notifi_list,a_notifi_list[Name 1 /vendor name]),a_notifi_list[Defective (external)],,DESC),a_...
rob7one A measure to capture supplier Rank by mm.yyyy and factory
Measure = RANKX ( FILTER ( ALL ( 'Table 1' ), 'Table 1'[mm.yyyy] = MAX ( 'Table 1'[mm.yyyy] ) && 'Table 1'[factory] = MAX ( 'Table 1'[factory] ) ), CALCULATE ( MAX ( 'Table 1'[amount of defects] ) ), , DESC, DENSE )PFA Workbook
Now, i would like to rank all the suppliers by amount of defects for every month and plant (in a common measure or column).
something like this:
The final result is to know often each supplier was in top five ranking (in the picture is top3) in the last 12 months and how often is every factory affected by this.
final report visual is this:
y-axis : vendors listed
x-axis amount of being present in top five ranking last 12 months (in every month)
legend: factory A, factory B, and so on
I hope it's clear a bit more now.