Forum Discussion

HR3038511's avatar
HR3038511
Icon for Helper I rankHelper I
1 year ago

Cumulative Sales by Rank

Hi,   I have a sales table with sales per sales agent. The table has a rank by sales. I need to calculate cumulative sales for the subsequent 3 ranks for each sales agent. Filters for category and ...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi HR3038511 

 

Please try this measure:

Subsequent 3 ranks = 
CALCULATE (
    SUM ( factSales[Sales] ),
    FILTER (
        ALL ( factSales[Rank] ),
        factSales[Rank] >= MAX ( factSales[Rank] )
            && factSales[Rank]
                <= MAX ( factSales[Rank] ) + 2
    )
)