Forum Discussion
Average
Hello All,
If I perform normal average function, see the DAX below
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
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]))
2 Replies
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]))