Cumulative sales total within a table using rank?

[cdawidow]

 Can anybody refer to me what formula I need to use to calculate the cumulative sales total within this table? I am having trouble doing so 

[Fowmy · Accepted solution]

@cdawidow 

You need to have a column like dates or any category that is related to each line where you can do the accumulation?

This would be that formula and needs to be adjusted. You share some table with dummy data. 

CALCULATE (
        SUM ( TableName[Sales Amount] ),        FILTER (
            ALL( TableName),
            TableName[Date] <= EARLIER ( TableName[DATE] )
        )
    ),

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Anonymous · Accepted solution]

@cdawidow Not very clear.

Do you want to obtain cumulative sales based on sales rank?

i.e. 1, 1+2, 1+2+3 .... 

[Fowmy · Accepted solution]

@cdawidow 

You need to have a column like dates or any category that is related to each line where you can do the accumulation?

This would be that formula and needs to be adjusted. You share some table with dummy data. 

CALCULATE (
        SUM ( TableName[Sales Amount] ),        FILTER (
            ALL( TableName),
            TableName[Date] <= EARLIER ( TableName[DATE] )
        )
    ),

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[harshnathani]

Hi @cdawidow ,

Not very clear but you can try this.

You can try this measure

RRT =
VAR _rankval =
    MAX ( 'Table'[SalesRank] )
RETURN
    CALCULATE (
        SUM ( 'Table'[Total Sales] ),
        'Table'[SalesRank] <= _rankval
    )

Incase this does not work share the sample data in text format and required output.

Regards,

Harsh Nathani