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 us...
Need Help
Show and Tell
Tips and Tricks
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.