Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
3 years ago
Solved

Table Average Required

The following code gives me the Average for each month going back 3 Financial Years (FY exists in my Date Table)

 

Averages = 
            VAR _table = SUMMARIZE(Date2,Date2[FY],"Count",COUNT('Cases'[incidentid]))
            RETURN
            AVERAGEX(_table,[Count])

 

How Do I replace the total below with an overall monthly Average?

 

Thanks

 

  • ArchStanton , try a measure like

    AVERAGEX(values(Date2[Month]),[Averages])

     

    or

     

    AVERAGEX(values(Date2[Month]),calculate(COUNT('Cases'[incidentid])))

2 Replies

  • ArchStanton , try a measure like

    AVERAGEX(values(Date2[Month]),[Averages])

     

    or

     

    AVERAGEX(values(Date2[Month]),calculate(COUNT('Cases'[incidentid])))