problem with matrix total

[Anonymous]

hi everyone.

I have 2 sales fields, one from 2019 and the other from 2018, the matrix is ​​seen per week. I made a measure so that if the sales field of 2019 has no value, the sale of 2018 cannot show its totals. When I put the values ​​in a matrix, the values ​​work out well, but the total adds up all the 2018 records that I have and not just the ones that I want to show 

[v-gizhi-msft]

hi,

According to your description, I create a similar table to test.

Please try to use ‘SUMX’ to calculate.

Result = SUMX(Table16,[2018sales]*[Check])

And it shows the true total as follows.

Here is my pbix test file.

pbix 

If you still have questions about this, please for free to let me know.

Best Regards,

Giotto Zhi

[Anonymous]

Hello, I tried to use the solution you gave me but the results come out in 0. I should point out that I have a general sale and I divided it into 2 to make one for the year 2019 and another for 2018 I don't know if this influences.
 
The origin of the problem is that I make a matrix with the accumulated daily and I compare it with the same period last year but at the time of accumulating what of 2019 if it has 3 days in 2018 I accumulate the whole week
 

[v-gizhi-msft]

hi,

Thanks for your reply.

Please share the pbix file with me if convenient. You can upload the pbix file to your OneDrive, paste the share link here.

And remember removing any sensitive data within the report.

Best Regards,

Giotto Zhi