Hello @hunghahuy,
Yes, the total in the measure - “Total Transaction in First 7 Days” is incorrect because even if, you export the data to cross-verify and take a sum of that column then the total will be 104 and not 67.
The reason why, you’re seeing the total as 67 is because at a grand total level there’s no context transferred and therefore, it took the First Date at an overall level i.e., 14-Aug-2019 and added 7 days to it. So it created a range from 14-Aug-2019 to 21-Aug-2019.
To cross-check the above explanation, go to the “Sales Orders” table and select the range from 14-Aug-2019 to 21-Aug-2019 and you’ll see 67 rows of data being filtered. Below is the screenshot provided for the reference -
In case, you would like to learn more about fixing totals. Below is the link of the post provided for the reference pertaining to the topic - “Fix Incorrect Totals”.
Thanks and Warm Regards,
Harsh