Replace Earlier in measure

[AlexGlz]

Hi all!

I'm trying to get a rank measure in order to get a TOP 5 in every hierarchy level in a visual.

For now I have four different columns with the corresponding Rank in every case of the Hierarchy level (Year-Quarter-Month-Day). I was just testing that the formula works, but cause I need to select the corresponding column based on a hierarchy, I can't make a simple "IF" column because it wouldn't react to the hierarchy drill.

So I tryed to make a measure with the same formula but I got stucked when the measure told me that I couldn't use the function EARLIER beacuse of the table context, so i need to repleace the formula with another fuction or something that let me do the same but without the EARLIER.

this is my first formula and if I solve this one i could solve the other ones without problem:

Year lvl Rank = RANKX(

FILTER(

          'LGE Block' ,

          'LGE Block'[MCBF]<>0 &&

          'LGE Block'[From Date].[Year] = EARLIER('LGE Block'[From Date].[Year])

),

'LGE Block'[MCBF],,ASC,Dense

)

Please if you have any ideas of how to take this formula into a measure would be very helpful to me

[v-xuding-msft]

Hi @AlexGlz ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here. If you are still confused about it, please share some sample data.

Best Regards,

Xue Ding

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

[v-xuding-msft]

Hi @AlexGlz ,

Maybe you could try the formula firstly. If it is not what you want, please share some sample data and  expected results. Then we will understand clearly.

Year lvl Rank =
RANKX (
    FILTER (
        ALL ( 'LGE Block' ),
        'LGE Block'[MCBF] <> 0
            && 'LGE Block'[From Date].[Year]
                = MAX ( 'LGE Block'[From Date].[Year] ) - 1
    ),
    'LGE Block'[MCBF],
    ,
    ASC,
    DENSE
)

Best Regards,

Xue Ding

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

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490