Forum Discussion
Advocate IIMatrix row totals not displaying correctly
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.
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
1 Reply
- v-luwang-msft
Community Support
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