Normalized Matrix Table Average Values

[Bootkie2]

Hello I have a PowerBI Matrix table and it is working great. But I am trying to create another matrix output table based on the results of this first table to normalize the numbers a little bit. Basically I want to take the Cell Value in the original table and subtract the Row Avearge x Column Average divided by the overeall average. I can create the new table very easily in Excel but can I do this in PowerBI too? How do I do it?

[Fowmy · Accepted solution]

@Bootkie2 

Try the following measure for your new matrix visual.

New Measure = 

var __rowtotal = CALCULATE([Average Online Sales],ALLSELECTED('rb_lysol_question_key'[Product Category]))
var __columntotal = CALCULATE([Average Online Sales],ALLSELECTED('rb_lysol_question_key'[Age]))
var __grandtotal = CALCULATE([Average Online Sales],ALLSELECTED())
var __result = 
   [Average Online Sales] -  
   DIVIDE(
       __rowtotal * __columntotal,
       __grandtotal
    )
return
    __result

[Bootkie2]

Awesome!