Average of Each Day's Count

[Anonymous]

Hi, I'm having a dataset like this:

I want to calculate the average of each day's count. Since the count for the same is the same, I want each day's count be only calculated once.

Here is what I want:

Average = (100+200+300+400) / 4

Divided by 4 because there are 4 days in total.

Is it possible to achieve this by writing measures? 

Any help is appreciated.

[amitchandak]

@Anonymous ,

Try like

divide(sumx(summarize(Table, Table[date],table[count]),[count]),distinctCOUNT(Table[Date]))

[mahoneypat · Accepted solution]

Please try this expression for a measure get your desired result (replacing Table with your actual table name)

New Measure = AVERAGEX(VALUES(Table[Date]), CALCULATE(AVERAGE(Table[Count])))

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat