Forum Discussion

rob7one's avatar
rob7one
Helper I
3 years ago
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_...
Need Help
  • smpa01's avatar
    smpa01
    3 years ago

    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

smpa01's avatar
smpa01
Community Champion
3 years ago

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

rob7one's avatar
rob7one
Helper I
3 years ago

That could really help! i will check it tomorrow to verify my results! Thanks a lot my friend!

 

i use this rankx measure for an other visual:

 

A_rank top 5 history 2 = RANKX(ALL(a_notifi_list[vendor name]), CALCULATE(SUM(a_notifi_list[Defectives)])))
 
it seems to work, but when i use it in a matrix like you can see below, it shows me for each vendor the value "1". i think that could be vendors which are not present with defects in the column of the month, but i'm not sure. Do you know how i can fix this? on the left side of the matrix are all vendors listed row by row.