Forum Discussion

Monty03's avatar
Monty03
New Member
4 years ago

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 th...
Need Help
mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
4 years ago

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's avatar
    Monty03
    New Member
    4 years ago

    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's avatar
      mangaus1111
      Icon for Solution Sage rankSolution Sage
      4 years ago

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