Forum Discussion

yaman123's avatar
yaman123
Post Partisan
5 years ago

Incorrect Row Subtotals

Hi all, 

 

I have an issue with a report i have created. The row subtotals do not sum correctly.  The Quantity field should show a total of 516 but instead it is showing as 512 - see below. I am using the standard matrix visual and no measures. I have added a column to the values box and done a distinct count on the column. 

 

Any help would be appreciated! 

 

Thanks

 

Need Help
Show and Tell
Tips and Tricks

5 Replies

    • yaman123's avatar
      yaman123
      Post Partisan
      5 years ago

      Hi, 

       

      So count of invoice no is the quantity field which is not summing correctly 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi yaman123 ,

     

    Did you pivot the data in Power Query, or did you use custom visual?

    For the issue of subtotals, we usually use HASONEVALUE to solve.

    Try like

    Measure=IF(HASONEVALUE('Table'[Days to Match Group]), RESULT1, RESULT2)
     
    Based on my test, the subtotals in the matrix is correct. 
     
     
     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • yaman123's avatar
      yaman123
      Post Partisan
      5 years ago

      Hi, 

       

      It is the standard matrix visual i am using. I am doing a distinct count of the invoice no to show me the quantity. The total should be 516 but it is showing as 512 for 0-1 days total quantity. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi yaman123 ,

         

        Can you provide me with more detailed information about your matrix and problem, or share your pbix file from Onedrive for Business with me?

         

        You can download my test file and compare it with yours.

         

        Best Regards,

        Stephen Tao

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.