Average

[Anonymous]

Hello All,

If I perform normal average function, see the DAX below

TimeAggActual = AVERAGEX(KPI_Reporting,KPI_Reporting[KPI_Comp1_Actual])

it is giving me  605/12=50.42 which total of Actual/total count of all months(12). But I would like to take only 6 month. ie. Is there any way to achieve this. so that it should take each month only once. Answer should be 605/6=100.83

[amitchandak · Accepted solution]

@Anonymous , Create a measure like

TimeAggActual = divide(sum(KPI_Reporting[KPI_Comp1_Actual]), distinctcount(Table[Month]))

or

divide(Sumx(Values(Table[Month]), calculate(AVERAGE(KPI_Reporting[KPI_Comp1_Actual]))), distinctcount(Table[Month]))

[Anonymous · Accepted solution]

Thanks its working.

[amitchandak · Accepted solution]

@Anonymous , Create a measure like

TimeAggActual = divide(sum(KPI_Reporting[KPI_Comp1_Actual]), distinctcount(Table[Month]))

or

divide(Sumx(Values(Table[Month]), calculate(AVERAGE(KPI_Reporting[KPI_Comp1_Actual]))), distinctcount(Table[Month]))