Forum Discussion
Average data rather than summed
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
5 Replies
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.
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.
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.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?Please send sample data of your table Sheet1 and your expected result.
