Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Ranking in matrix doesn't work with filter

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 = ALLSELE...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try

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

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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