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 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 

Need Help

3 Replies

  • 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