Total amount for Top N

[bjoshi]

Hi,

I have two measures: 

Total Revenue = Sum(DSS[Revenue])

RankDebtors = RANKX(All(DSS[Debtors]),[Total Revenue])

Now, I need another measure which gives me the Total Revenue for Top 10 Debtors. I have tried few formulas including this:

RevenueTop10Debtors = CALCULATE(SUM(DSS[Revenue]), FILTER(DSS,[RankDebtors]<=10)).

But, I couldn't get it to work. What should the measure be written?

[Sean · Accepted solution]

@bjoshi  How about this?

RevenueTop10Debtors =
CALCULATE (
    [Total Revenue],
    TOPN ( 10, ALL ( DSS[Debtors] ), [RankDebtors], ASC )
)

HTH!

BTW try this also you were almost there...

RevenueTop10Debtors =
CALCULATE (
    [Total Revenue],
    FILTER ( ALL ( DSS[Debtors] ), [RankDebtors] <= 10 )
)

Both these Measures should give you the same result!