Incorrect Row Subtotals

[yaman123]

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

[Anonymous]

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]

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]

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.

[VijayP]

@yaman123 

Sample Data allows to give a good solution

[yaman123]

Hi, 

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