Help with Ranking based off Measure over multiple Sub Accounts

[Anonymous]

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 ones that have a variance "VY".

There are two levels of chart account groupings. The "Chart Acct Number Name" and a Sub group "Specific Acct Number Name"

Thanks so much for any help!

Trevor

Here is my Ranking calculation so far:

Rank, Chart Acct =

IF(HASONEVALUE(MonthlyFinancials[Chart Acct Number Name]),

RANKX(

FILTER(ALL(MonthlyFinancials[Specific Acct Number Name]),

[Assets $ VY]<>BLANK()),

[Assets $ VY],,ASC,Skip),

BLANK()

)

[amitchandak]

@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])