Ranking in matrix doesn't work with filter

[Anonymous]

Hello everyone ! 

I'm trying to rank my total weight per client (name 1 in the matrix).

To do this, I used this formula which gives me a correct ranking :

Ranking  =
VAR Customers =
ALLSELECTED(ZV048[Name 1])
VAR Result =
CALCULATE(
RANKX(Customers, ZV048[Total weight formula],, DESC, DENSE ),
REMOVEFILTERS( ZV048 ),
VALUES('Calendar'[Date].[Année]),
VALUES(ZV048[Name 1]),
ALLSELECTED(ZV048[Shipping type])
)

RETURN
Result

However, when I use my Shipping type filter, the ranking does not act intelligently : 

Indeed, by choosing a shipping type filter I would like to have a ranking starting from 1.

Any idea? 

Thank you.

Regards,

Ilias

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please check this formula.

Ranking =
CALCULATE (
    RANKX (
        FILTER (
            ALLSELECTED ( ZV048 ),
            ZV048[Name 1] = SELECTEDVALUE ( ZV048[Name 1] )
        ),
        ZV048[Total weight formula],
        ,
        DESC,
        DENSE
    ),
    ALLSELECTED ( 'Calendar'[Date].[Année] )
)

If it doesn't work, please share the pbix to us so that we could test formula.

Best Regards,

Jay

[amitchandak]

@Anonymous , Try

RANKX(Summarize(allselected(ZV048), ZV048[Name 1],'Calendar'[Date],ZV048[Shipping type] ), ZV048[Total weight formula],, DESC, DENSE )

[Anonymous]

Thank you @amitchandak ,

Here is the result using this formula :

Various clients have the same ranking.

And using a shipping type filter: 

Maybe something wrong with my Total weight formula ?

Total weight formula = SUM(ZV048[Total Weight])

Ilias