Measure calculation not coming correct

[Anonymous]

HI All,

I have a simple data set

Date	Sales
21-02-2019	10
22-02-2019	10
23-02-2019	10
24-02-2019	10

creted a measure to calculated the max date

max_date = MAX(Sheet1[Date]) i.e 24-02-2019

now when I am summing up the sales for max date I am getting 40 instead of 10 on that date

sale_sum = CALCULATE(sum(Sheet1[Sales]),FILTER(Sheet1,Sheet1[Date]=[max_date])) (however if i hard code "24-02-2019" I am getting 10)

[Anonymous · Accepted solution]

Try this measure:

sale_sum = CALCULATE(sum(Sheet1[Sales]),FILTER(Sheet1,Sheet1[Date]=MAX( Sheet1[Date]) ) )

Thanks

Raj