Forum Discussion

bjoshi's avatar
bjoshi
Resolver I
9 years ago
Solved

Total amount for Top N

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?

 

 

 

Need Help
  • Sean's avatar
    Sean
    9 years ago

    bjoshi  How about this?

     

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

    HTH! :smileyhappy:

     

    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! :smileyhappy:

1 Reply

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    bjoshi  How about this?

     

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

    HTH! :smileyhappy:

     

    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! :smileyhappy: