Problem with RANKX

[Steve_L]

Hi I try to create a rank measure, it works if I only have SKU and rank in the pivot table, but once I put product name column, all of the products return 1, is there any reason why? How can I rewrite my code? Thanks a lot!

=RANKX (
    ALL ( 'Total Sales'[SKU] ),
    CALCULATE (
        SUM ( 'Total Sales'[Value] ),
        'Total Sales'[Value Type] = "Gr Sales",
        DATESINPERIOD (
            'Total Sales'[Month/Year],
            LASTDATE ( 'Total Sales'[Month/Year] ),
            -12,
            MONTH
        )
    ),
    ,
    DESC,
    DENSE
)

This code works exactly what I want when I have below pivot table setting:

SKU	Rank
111	1
222	2
333	3
444	4

 However, the code returns all 1 when I add one more row field in above table:

SKU	Product Name	Rank
111	aaa	1
222	bbb	1
333	ccc	1
444	ddd	1

[Zubair_Muhammad · Accepted solution]

Hi @Steve_L

Try Modifying this part

=RANKX (
    ALL ( 'Total Sales'[SKU] , 'Total Sales'[Product Name])

[Steve_L]

Thanks @Zubair_Muhammad

You are the rock!

By the way, why is it work once I change my code like this?