Table subtotal is incorrect

Hi, Anonymous 

According to your description, I suggest you to use the Summarize() function to define a new table to get the correct total value, you can try to create new measures for the measures [<200], [>200], and [Compliance (CPDD < 200)] like this:

<200_new=

var _new=SUMMARIZE('Table','Table'[Region],"_value",[<200])

return IF(HASONEVALUE('Table'[Region]),[<200],SUMX(_new,[_value]))

>200_new=

var _new=SUMMARIZE('Table','Table'[Region],"_value",[>200])

return IF(HASONEVALUE('Table'[Region]),[>200],SUMX(_new,[_value]))

Compliance (CPDD < 200)_new=

var _new=SUMMARIZE('Table','Table'[Region],"_value",[ Compliance (CPDD < 200)])

return IF(HASONEVALUE('Table'[Region]),[ Compliance (CPDD < 200)],SUMX(_new,[_value]))

And you can get what you want.

You can also refer to these links:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

https://community.powerbi.com/t5/Desktop/How-to-show-total-row-as-sum-of-distinct-count/td-p/1416468

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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