Forum Discussion

PolarBear's avatar
PolarBear
Icon for Helper I rankHelper I
6 years ago
Solved

Rankx by Group with filter

Good Morning, I've tried googling this for a couple of days now but haven't found a solution that works for me..and my deadline is tomorrow 😕   I have a summarize table that I need to rank by cat...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi PolarBear ,

     

    Please update your formula as below.

    ank = 
IF (
    Weekly_Stats[Count] > 999,
    RANKX (
        FILTER (
            Weekly_Stats,
            Weekly_Stats[YearWeekNum] = EARLIER ( Weekly_Stats[YearWeekNum] )
                && Weekly_Stats[Count] > 999
        ),
        Weekly_Stats[Avg.],
        ,
        DESC,
        DENSE
    ),
    BLANK ()
)

     

    Also attached the pbix.

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi PolarBear ,

 

Please update your formula as below.

ank = 
IF (
    Weekly_Stats[Count] > 999,
    RANKX (
        FILTER (
            Weekly_Stats,
            Weekly_Stats[YearWeekNum] = EARLIER ( Weekly_Stats[YearWeekNum] )
                && Weekly_Stats[Count] > 999
        ),
        Weekly_Stats[Avg.],
        ,
        DESC,
        DENSE
    ),
    BLANK ()
)

 

Also attached the pbix.