Wrong totals for calculated measure

[catleen]

Hi!

I know this kind of problem is described in the forum quite many times, but i can't seem to find a solution to fix my issue.

So basically the table total is wrong.

The measure I am trying to sum is: Sales LY = calculate(sum(Table1[Sales EUR]);SAMEPERIODLASTYEAR(Departure_date[Departure Date]);FILTER(SAMEPERIODLASTYEAR(Issued_date[Sales Date]);Issued_date[Sales Date]<=(max(Table1[Issued Calendar Date])-[LAG]))).

In Table1 I have several other measures which I am using to filter the data. For example:

Any ideas how to fix it? I suppose I would need to add something to the measure I am using?

Thanks for the help!

[v-qiuyu-msft]

Hi @catleen,

I notice there are three tables Table1, Departure_date, Issued_date used in the measure, would you please share some dummy data about this three tables and expected results for us to test it?

Best Regards,
Qiuyun Yu