cancel
Showing results for
Did you mean:
Highlighted
Member

## Calculate Av of Column of Data

Hi Experts

I have calculate the average for each of the business sectors as shown in the screen shot, the problem i am facing is how do i calculate the averge of the data as shown so 186/16 = 11.67%

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

## Re: Calculate Av of Column of Data

Hi @Route11,

Based on my test, you could refer to below formula:

Measure 2 = AVERAGEX('Table1','Table1'[Measure])

Result:

https://www.dropbox.com/s/5rxglrvnanf2oqg/Calculate%20Av%20of%20Column%20of%20Data.pbix?dl=0

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Member

## Calculate Average of Formula

Hi Experts

How would you calculate the Average of the following measure..

= IF(DIVIDE([Act],COUNT(Case_Data[Apples]),0)=BLANK(),0,(DIVIDE([Act],COUNT(Case_Data[Apples]),0)))

Microsoft

## Re: Calculate Av of Column of Data

Hi @Route11,

Based on my test, you could refer to below formula:

Measure 2 = AVERAGEX('Table1','Table1'[Measure])

Result:

https://www.dropbox.com/s/5rxglrvnanf2oqg/Calculate%20Av%20of%20Column%20of%20Data.pbix?dl=0

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

## Re: Calculate Av of Column of Data

Thanks Daniel...

Understand the logic here, much appreciated with the feedback

Microsoft

## Re: Calculate Av of Column of Data

Hi @Route11,

Could you please explain me the logic here and post your desired picture if possible?

Regards,

Danile He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!