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

rob7one's avatar
rob7one
Helper I
3 years ago

Hello Charlotte 🙂

 

here is a table with sample data:

 

mm.yyyyfactorysupplieramount of defects
01.2022Bxx12
01.2022Ccc23
03.2022Dyx34
01.2022Ayc45
03.2022Bxy56
01.2022Dcx1
03.2022Axx0
01.2022Bcc8
01.2022Dcx300
01.2022Axy23
01.2022Bcy65
02.2022Cer87
02.2022Dtr11
01.2022Cxc65
01.2022Dcx300
01.2022Axy23
01.2022Bcy65
02.2022C tz87
02.2022D kl67
02.2022Eqw101
03.2022C tz87
02.2022D kl67
02.2022Eqw101
02.2022Eqw101
02.2022C tz87
02.2022D kl67
02.2022Eqw101
02.2022C tz87
02.2022D kl67
02.2022Eqw101
02.2022C tz87
02.2022D kl67
03.2022Eqw101
03.2022C tz87
03.2022D kl67
02.2022Eqw101
03.2022C tz87
02.2022D kl67
02.2022Eqw101
02.2022C tz87
03.2022D kl67
02.2022Eqw101
01.2022Ayy1
01.2022Bxx12
01.2022Ccc23
03.2022Dyx34
01.2022Ayc45
03.2022Bxy56
01.2022Ccy56
01.2022Dxc45
01.2022Acx34
01.2022Byx23
01.2022Ccx12
01.2022Dcx1
03.2022Axx0
01.2022Bcc8
01.2022Cxc65
01.2022Dcx300
01.2022Axy23
04.2022Bcy65
02.2022Cer87
02.2022Dtr11
04.2022Cxc65
01.2022Dcx300
01.2022Axy23
01.2022Bcy65
02.2022C tz87
02.2022D kl67
02.2022Eqw101
03.2022C tz87
02.2022D kl67
02.2022Eqw101
02.2022C tz87
02.2022D kl67
02.2022Eqw101
02.2022C tz87
04.2022D kl67
02.2022Eqw101
02.2022D kl67
02.2022Eqw101
02.2022C tz87
02.2022D kl67
02.2022Eqw101
02.2022C tz87
02.2022D kl67
04.2022Eqw101
02.2022C tz87
02.2022C tz87
02.2022D kl67
02.2022Eqw101
03.2022Eqw101
03.2022C tz87
03.2022D kl67
03.2022C tz87
04.2022C tz87
04.2022D kl67
04.2022Eqw101
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.