cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Average of Each Day's Count

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.

1 ACCEPTED SOLUTION
Microsoft Employee

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

2 REPLIES 2
Super User

@Anonymous ,

Try like

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

Microsoft Employee

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.