Calculate Av of Column of Data

[Anonymous]

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% 

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

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

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

Result:

You can also download the PBIX file to have a view.

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

Regards,

Daniel He

[Anonymous]

Thanks Daniel...

Understand the logic here, much appreciated with the feedback

[v-danhe-msft]

Hi @Anonymous,

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

Regards,

Danile He

[Anonymous]

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)))