Calculate Sales from start date

[AdilFS]

Need to calculate sales of a shop from start date of a shop.
I have 2 tables : Sales and Date
In Sales table I have information about volume of sales.
In Date table I have shop start date.
I have tried to use that code:

SWS comp = 
CALCULATE(Sales[sales], [Start Date] >= [Start Date])​

[devanshi]

Total Sales = 
VAR startdate = FIRSTDATE([Startdate])
CALCULATE(SUM([Sales]) , [Startdate] >= startdate)

[AdilFS]

There is an issue with syntax

[devanshi · Accepted solution]

Try this once,

CALCULATE(SUM([Sales]), ALL(Tablename), [Startdate]>=MIN([Startdate]))

[AdilFS]

Any other way?

[devanshi]

If you have ID of shop or sales you can try this:

Total Sales = CALCULATE(SUM([Sales]) ,
                                             FILTER('Tablename', [SalesID] =  SELECTEDVALUE([SalesID]) && 
                                                              [StartDate] = MIN[StartDate]                                                                                                        )
                                )