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 De...
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:

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: