topic Re: Create a measure to show average on % in the Matix visual in DAX Commands and Tips

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

surajbh — Tue, 07 May 2024 09:03:56 GMT

	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.

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

bhanu_gautam — Tue, 07 May 2024 09:52:18 GMT

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

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

Anonymous — Wed, 08 May 2024 07:16:36 GMT

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.

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

surajbh — Mon, 13 May 2024 07:51:05 GMT

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.