Creating Total Row for Matrix Table

[ok_kpop]

I'm trying to create a total row in a matrix table similar to the Excel example pictured below. I want the sum of "A" and "B" for each day as well as the absolute average % difference of "A". Formula I used in Excel to calculate is pictured up top. I've also added my dummy pbix file below. I've spent hours trying to do this and not the best as creating measures. Please help ASAP!

 Dummy File 

[ok_kpop]

Hi there. Thanks for responding. The totals for "A" and "B" were perfect. But, ideally, I would like to keep the original % difference values with the negative values in the table and just do the absolute average as the total like in the picture below. Is that possible to do? I've also attached my updated dummy file. 

Dummy File 2 

[Kishore_KVN]

Hello @ok_kpop ,

You have to create measures instead of taking those columns directly. Create three measures as below and drag them in the values field of the visual. So the three measures are as below:

Total A = SUMX(Sheet1,Sheet1[A])

Total B = SUMX(Sheet1,Sheet1[B])

Difference Average = AVERAGEX(Sheet1,ABS(Sheet1[% Difference]))

Your output looks like below:

Dont forget to turnon row sub totals at last. 

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