Matrix row totals not displaying correctly

[Michaelbean21]

I am experiencing row totals that are not equaling my complete total.  Does anyone know why this happens or have a solution?


Here is my DAX to get that count.

Here is the table where I am calling to build that DAX.

[v-luwang-msft · Accepted solution]

Hi @Michaelbean21 ，

You need to create a new measure, by using sumx(table,[strata count]), to get the cumulative composite, after screening by using hasonevalue：

if(hasonevalue(Table[Region name]),[strata count],totalmeasure)))

Similar question refer:

https://community.powerbi.com/t5/Desktop/Matrix-Totals-error/m-p/1499809 

https://community.powerbi.com/t5/Desktop/Matrix-Not-Totalling-Correctly-By-Rows/m-p/2168768 

Best Regards

Lucien