Add new value/column in power BI matrix

Question

i created matrix in power bi. and i want to add sales average at last column and the formula i stated below. its just sample formula. but when i create a measure and add the measure at value. the column is repeating beside each column. how to add the column at last column only.

the result i want.

the result im getting

Answer 1

This is how a matrix works out of the box. What you want is called an asymmetric matrix and instructions can be found here: https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/