Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

problem with matrix total

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...
Need Help
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      v-gizhi-msft
      Community Support
      6 years ago

      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