Forum Discussion

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

7 years ago

alexei7

As a calc column,,,try

Calc Column =
RANKX (
    Table1,
    CALCULATE (
        SUM ( [Invoice Amount] ),
        ALLEXCEPT ( Table1, Table1[SupplierCode] )
    ),
    ,
    DESC,
    DENSE
)

Zubair_Muhammad

Community Champion

7 years ago

alexei7

Any number of columns shouldn't make a difference I believe.

Could you share your file?

Is the result below from a Table Visual in Report....Perhaps it is summing the RANKs...may be you need to mark the RANK column as "Dont summarize"

Could you share screen shot from dataview