topic Re: Correct subtotals but incorrect grand total in DAX Commands and Tips

Correct subtotals but incorrect grand total

vat2do — Tue, 09 Jul 2024 10:04:27 GMT

HI experts,

I am facing an issue with the grand total in a matrix visual, I already use SUMX and Summarize functions to correct my subtotals of the rows, but again the Grand total is wrong . it should be 3263 and not 3254.

Can someone provide a work around to get a gorrect GRAND TOTAL in a matrix.

Thanks in advance

Re: Correct subtotals but incorrect grand total

lbendlin — Fri, 12 Jul 2024 00:48:01 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Correct subtotals but incorrect grand total

vat2do — Sun, 14 Jul 2024 08:21:22 GMT

Thanks lbendlin for sharing the guidelines.

Below mentioned is the link for sample pbx file.

https://we.tl/t-M5aoGN84Tg

I am having the same issue of getting incorrect sub totals and overall Grand total at the Area and Region levels. Will be thankful to have a solution inorder to get the correct subtotals and grand total based on the sample file provided.

Regards

Re: Correct subtotals but incorrect grand total

vat2do — Mon, 15 Jul 2024 09:44:16 GMT

rajendraongole1 , Jihwan_Kim , mark_endicott

Dear Experts,

Appreciate to have acorrect DAX measure to be used inorder to get correct subtotals and grand totals in matrix view, PBX file is already attached with below link.

https://we.tl/t-M5aoGN84Tg

Thanks in advance

Re: Correct subtotals but incorrect grand total

Jihwan_Kim — Mon, 15 Jul 2024 18:21:30 GMT

Hi,

I am not sure if I understood your question correctly, but please try something like below if it suits your requirement.

No. of companies = SUMX ( SUMMARIZE ( 'Sample Data', 'Sample Data'[Region], 'Sample Data'[Area ] ), CALCULATE ( DISTINCTCOUNT ( 'Sample Data'[Company ] ) ) )

Re: Correct subtotals but incorrect grand total

Anonymous — Thu, 25 Jul 2024 08:27:43 GMT

Hi vat2do

Thanks for the reply from lbendlin and Jihwan_Kim .

vat2do , did Jihwan_Kim ‘s answer help you? If so, please accept it as a solution. This will be of great help to other users who have similar problems as you. Thank you!

If you still have questions, please let us know.

Best Regards,
Yulia Xu