Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Rankx on a matrix

i am trying to do rankx on a matrix table but when i drill down i would like the rankx to recalculate when i drill down, currently i have the following fields in my matrix and want to do the rank by ...
Need Help
Show and Tell
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You may create measure like DAX below .

Endleaf Rank =
SWITCH (
    TRUE (),
    ISINSCOPE ( Sales[Username] ), RANKX (
        ALLSELECTED ( Sales[Username] ),
        CALCULATE ( SUM ( Sales[Point] ) ),
        ,
        DESC,
        DENSE
    ),
    ISINSCOPE ( Sales[Date].[Month] ), RANKX (
        ALLSELECTED ( Saless[Date].[Month] ),
        CALCULATE ( SUM ( Sales[Point] ) ),
        ,
        DESC,
        DENSE
    ),
    ISINSCOPE ( Sales[store]]] ), RANKX (
        ALLSELECTED ( Store[store] ),
        CALCULATE ( SUM ( Sales[Point] ) ),
        ,
        DESC,
        DENSE
    ),
    ISINSCOPE ( Sales[Product]]] ), RANKX (
        ALLSELECTED ( Store[Product] ),
        CALCULATE ( SUM ( Sales[Point] ) ),
        ,
        DESC,
        DENSE
    )
)

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    thanks amy, still not geting the outcome i would expect as i am still getting just loads of 1 when i drill down;