Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Average

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 A...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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's avatar
    Anonymous
    5 years ago

    Thanks its working.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks its working.