DAX formula for calculating average for particular category is not working

[jaydesai28]

I made one measure for calcualting average execution time per report but it does not work.

AverageExecutionTime = CALCULATE(AVERAGE(ReportFields[TotalTime]),ALLEXCEPT(ReportFields,ReportFields[ReportName]))

I am using  Direct Query mode.

[Anonymous]

@jaydesai28

You look close. You might want to try swapping out the ALLEXCEPT for ALLSELECTED.

AverageExecutionTime = CALCULATE(AVERAGE(ReportFields[TotalTime]),ALLSELECTED(ReportFields[ReportName]))

Hope this helps,

Parker

[jaydesai28]

It does not wotk either.

[Anonymous]

Try this:

AverageExecutionTime = 
VAR CurrentReport = FIRSTNONBLANK(ReportFields[ReportName]),1)
RETURN
CALCULATE(
   AVERAGE(ReportFields[TotalTime]),
   FILTER(
      ALL(ReportFields),
      ReportFields[ReportName] = CurrentReport
   )
)

[dtartaglia · Accepted solution]

I'm not 100% sure what your looking for but if I create a calculated column using:

AverageExecutionTime = CALCULATE(AVERAGEA(Sheet1[TotalTime]),ALLEXCEPT(Sheet1, Sheet1[ReportName]))

I get:

[jaydesai28]

It doesn't work please refer to this question

https://stackoverflow.com/questions/51313866/while-applying-relative-date-filter-and-adding-measure-...