Forum Discussion

Ritesh_Air's avatar
Ritesh_Air
Post Patron
6 years ago
Solved

RankX and filter certain amounts

Hi,   I want to rank certain things and exclude something which is below threshold. This below formulas works fine. Product Marketing Brand asc = VAR PRODCUTRANKX = RANKX ( ALL ( 'Pr...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Ritesh_Air ,

     

    Would you please refer to the following measure:

     

    Product Marketing Brand asc =
VAR PRODCUTRANKX =
    IF (
        [Net Sales] > 1000,
        RANKX (
            FILTER ( ALL ( 'Product'[Product Marketing Brand] ), [Net Sales] > 1000 ),
            CALCULATE ( [Net Sales] ),
            ,
            ASC,
            DENSE
        ),
        BLANK ()
    )
RETURN
    PRODCUTRANKX

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi Ritesh_Air ,

 

Would you please refer to the following measure:

 

Product Marketing Brand asc =
VAR PRODCUTRANKX =
    IF (
        [Net Sales] > 1000,
        RANKX (
            FILTER ( ALL ( 'Product'[Product Marketing Brand] ), [Net Sales] > 1000 ),
            CALCULATE ( [Net Sales] ),
            ,
            ASC,
            DENSE
        ),
        BLANK ()
    )
RETURN
    PRODCUTRANKX

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Ritesh_Air's avatar
Ritesh_Air
Post Patron
6 years ago

v-deddai1-msft 

 

Thanks. This is exactly what I was looking for.