How to calculate Average per type/category?

[Nazish]

Hi PowerBi Community,

I want to calculate Average of RespTimeMins by Issue Type (monthly and yearly) and I have below data columns (Issue Type, RespTimeMins, month and year) in my table. 

please help me how I can get this Averge by Issue Type? Thankyou

Intended Output:

Issue Type	Average RespTimeMins	Year	month
Connected Vehicle IT	0	2021	1
IT Services	560.33	2021	1
Software	363.75	2021	1
Transit IT	1018.42	2021	1

[Syk]

You should be able to create a measure to find the Average Resp Time and then add the year and month as fields to a table.

Average_response_time_minutes = AVERAGE(table[RespTimeMins])

[Nazish]

Hello @Syk ,

This measure gives Total average but not Averge per Issue Type. please check below output 

but I want Average per Issue type like below;

Issue Type	Average RespTimeMins
Connected Vehicle IT	0
IT Services	560.33
Software	363.75
Transit IT	1018.42

[Syk]

Lets try to just set the field in the table visual.. If you go to the field in the table it should look something like this..

Select the 'Average' for your response time field and you should get the average for whatever types or date ranges you have in your table 

[Nazish]

Have you used the same syntax for Average Measure? Because even I selected "Average" for response time field but still the same result. its showing 1070.77 for all of issue types.

Am I mistaking somewhere else?

Can you please check below screenshot

[Syk · Accepted solution]

Remove the measure and just put the response time field in the table then select average. (No measure needed for this)

[Nazish]

Ok, Thankyou so much. It worked now.

Can you please also share how I can convert the Minutes to Days and Hours?

Thankyou.

[Syk]

Set your data type to duration and then you can select which type of duration you want to convert it to.

[Nazish]

Thankyou so much, I have been looking for this solution from so many days but wasnt getting it. You have helped me alot.

Thankyou so much again. much apperciated.