How to achieve Grand total

[MSMKM]

Hi Team,

i have table refer the below table1 and refer the 2 nd table shows, there are M_sales colums two row values not there but still getting grand total is same for what is sales total.

how we can acheive 

Product	Count	Sales
A	10	143
B	15	156
C	5	138
D	3	198
E	12	168
Total	45	803

Product	Count	Sales	M_sales
A	10	143	143
B	15	156	156
C	5	138
D	3	198
E	12	168	168
Total	45	803	803

[amitchandak]

@MSMKM , is M_sales is a measure using row context?

if yes try like

Sumx(values(Table[product]), [M_sales] )