Forum Discussion

alexei7's avatar
alexei7
Continued Contributor
7 years ago
Solved

RANKX DAX column help

Hi, I'm trying to create a column that will rank Invoices across Suppliers. This needs to be a column so that I can then use this Rank column to create a cumulative total and then (hopefully a meas...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    alexei7

     

    As a calc column,,,try

     

    Calc Column =
RANKX (
    Table1,
    CALCULATE (
        SUM ( [Invoice Amount] ),
        ALLEXCEPT ( Table1, Table1[SupplierCode] )
    ),
    ,
    DESC,
    DENSE
)
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi alexei7,

 

To create two measures as below.

 

total = CALCULATE(SUM(Table1[Invoice Amount]),ALLEXCEPT(Table1,Table1[SupplierCode]))
rankx = RANKX(ALLSELECTED(Table1[SupplierCode]),[total],,DESC,Skip)

 

Also to create a calculated columm worked well.

 

rankxcc = RANKX(ALLSELECTED(Table1[SupplierCode]),[total],,DESC,Skip)

 

For more details, please check the pbix as attached.

 

Regards,

Frank