Correct subtotals but incorrect grand total

[vat2do]

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

[lbendlin]

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

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/1447...

[vat2do]

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

[vat2do]

@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

[Anonymous]

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

[Jihwan_Kim · Accepted solution]

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