Average data rather than summed

[Monty03]

Hi, I have a calculated column of 'lead times' calcualted from the submission date and completed date.  I also have a column of 'departments'  When I build a pie chart or any other visual, it sums the departments lead times whereas I want to show an average leadtime for each department.  Is there any way to do this?  Thanks in advance

[mangaus1111]

Which data type has the column Lead Time?

Try with this measure and put it in the Values field

Avg = AVERAGE(Facts38[Lead Time])

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

[Monty03]

Thanks for the response.  The values 'lead time' is calculated as follows:

Lead Time =

AVERAGEX(

Sheet1,

IF(ISBLANK(Sheet1[Date Completed].[Date]),DATEDIFF(Sheet1[Submission Date].[Date], TODAY(),DAY),DATEDIFF(Sheet1[Submission Date].[Date],Sheet1[Date Completed].[Date],DAY)

))

This is the first time I have used DAX and I can't actually see a column of data...

I notice the box 'Data Category' is 'uncatergorized', could this have an affect?

[mangaus1111]

Please send sample data of your table Sheet1 and your expected result.

[Monty03]

Thanks for the reply, this is what I was expecting to see and have done that in the past but I have no option there.  Here is what I see.

[mangaus1111]

Hi @Monty03 ,

try to select from here the avaerage, instead of the sum

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