Create a measure to show average on % in the Matix visual

[surajbh]

	Januar	Januar	Feb	Feb	March	March	April	April	Avergage	Avergage
	speed	Velocity	speed	Velocity	speed	Velocity	speed	Velocity	speed	Velocity
Truck 1	71%	69%	75%	78%	42%	48%	87%	78%
Truck 2	78%	15%	14%	46%	71%	69%	75%	87%
Truck 3	77%	68%	42%	65%	68%	78%	45%	52%
Truck 4	71%	69%	78%	72%	89%	69%	85%	79%

I would like to calculate the average speed and velocity and display them at the end of the table, as shown above. I am curious if there is a way to show the average as a percentage of the months displayed in the table. Any guidance on how to achieve this would be greatly appreciated. Thank you very much.

[Anonymous · Accepted solution]

Hi @surajbh ,

First of all, many thanks to @bhanu_gautam  for your very quick and effective replies.

Based on my testing, please try the following methods as workaround:

1.Create the simple table.

2.Create the new measure to calculate average.

Average = 
VAR valu_ = SUM('Table'[Values])
VAR spee = CALCULATE(SUM('Table'[Values]), ALLEXCEPT('Table', 'Table'[Truck], 'Table'[Sped]))
VAR spe_count = DISTINCTCOUNT('Table'[Month])
VAR result = DIVIDE(spee, 4)
RETURN
result

3.Drag the measure into the matrix visual.

4.Change the measure format to the percentage.

5.The result is shown below.

Best Regards,

Wisdom Wu

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

[surajbh]

@Anonymous thank you for the file and answer. well apperciate it.
i see average is always repeated in the column,
but i would like to show at the end of the table, like the way total is shown but would like to show average ( in %) in the last column.  
i think when writing the formula in average, i should write something so that it ignore it on the month columns but shows in the last column only. 
could you please help if possible, any lead is always appreciated. 

thanks.

[bhanu_gautam]

@surajbh , You can create a simple measure for Average speed and Average Velocity 

Average Speed = AVERAGE('TableName'[speed])

Average Velocity = AVERAGE('TableName'[velocity])

And for Percentage you can use this measure

Average Percentage = DIVIDE([Average Speed], COUNTROWS('TableName') / COUNTA('TableName'[speed]) * 100, 0