Forum Discussion

HitcH's avatar
HitcH
Icon for Helper II rankHelper II
3 years ago
Solved

Rank not working

Hello Power BI people I want to see the rank of my products, based on sales, but I get some multiple ranks: As you can see RANKkK is showing 6 rank 1 and 3 rank 5. This is the formula that I'...
Need Help
  • HitcH's avatar
    HitcH
    3 years ago

    Auto - Solved

    The correct formula:

    RANKkK = RANKX(ALL(Controlling[VIB]), CALCULATE(sum(Controlling[Fatt. lordo])), ,DESC)
pratyashasamal's avatar
pratyashasamal
Icon for Memorable Member rankMemorable Member
3 years ago

Hi HitcH ,
You try this type of calculation :-
For example

Ranking on Brand :=
IF (
    ISINSCOPE ( 'Product'[Brand] ),
    RANKX (
        ALLSELECTED ( 'Product'[Brand] ),
        [Sales Amount]
    )
)Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
HitcH's avatar
HitcH
Icon for Helper II rankHelper II
3 years ago

Uppp 😪