Incorrect Total in matrix

[Yashh]

Hello All,

in this I am having trouble in figuring out the correct sum in the matrix table.

[amitchandak]

@Yashh , if you are using row context, this can refer

refer approach

https://www.youtube.com/watch?v=ufHOOLdi_jk

[Yashh]

Hello @amitchandak 

Please could you help me out with this particular data as I am not able to figure it out.
Best Regards

[amitchandak]

@Yashh , Assume you are using measure m1 and field on the matrix column is flag

Then use this measure instead

m2 = sumx(Values(Table[Flag]), [M1])