Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help with Ranking based off Measure over multiple Sub Accounts

Hi,   Can someone help me with this ranking formula for my tool tip. I want to highlight the largest variance with a ranking. I dont want blank accounts to be calculated in this ranking, just the o...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , check these three measures. See if is in scope can help. Assumed Specific Acct Number Name is the child , second in row

 

R1 =
RANKX(
FILTER(ALL(MonthlyFinancials[Specific Acct Number Name], MonthlyFinancials[Chart Acct Number Name]),
[Chart Acct Number Name] = max([Chart Acct Number Name])
[Assets $ VY]<>BLANK()),
[Assets $ VY],,ASC,Skip)

R2 = RANKX(
FILTER(ALL(MonthlyFinancials[Specific Acct Number Name]),
[Assets $ VY]<>BLANK()),
[Assets $ VY],,ASC,Skip)


Rank, Chart Acct = if (isinscope(MonthlyFinancials[Specific Acct Number Name]) , [R1], [R2])