New custom line of Average of total in matrix

[Anonymous]

Hi all,

I need to achieve the outcome below:

For example: I have City in rows, year on columns and I need to add the line in red which is the Average of total. is this possible?

My table only has the city as below and I don't have the line for the average of total in the model

[amitchandak · Accepted solution]

@Anonymous , You can change the total as Average, but having a line means custom table creation.

Total as Avg for a  measure

Over all Avg= averagex(Values(Table[City]),[Measure])

Another way is to add a dummy column in the city table

New column = Average of City

Then try a measure like

if(isinscope(Table[Average of City]) && not(isinscope(Table[City] )) , [Over all Avg],[Measure])