- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# calculate average of measures

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-03-2018 03:05 PM

Hello guys,

I have a table with a list of certificates with some information split by arquetipoID.

First, I created a measure (**QT Arquet**) to count the number of certificates by class(arquetipoID)

**QT Arquet** = CALCULATE(*DISTINCTCOUNT(Lista_Arquetipos[Nº CE]))*

Then, count the number of certificates that have values based on these 2 measures (**Heat_elect_1 and Heat_elect_2)**

**Heat_elect_1**=*CALCULATE(*

*DISTINCTCOUNT('Equipamento'[Nº CE]);**FILTER(Equipamento;Equipamento[Fonte de Energia]="Eletricidade");**FILTER(Equipamento;Equipamento[Função 1]="Aquecimento")**)*

**Heat_elect_2**=*CALCULATE(*

*DISTINCTCOUNT('Equipamento'[Nº CE]);**FILTER(Equipamento;Equipamento[Fonte de Energia]="Eletricidade");**FILTER(Equipamento;Equipamento[Função 2]="Aquecimento")**)*

*Now in the second part, **I am trying to calculate the average value of occurrences by ArquetipoID and **I created*

**Avg_Heat_Elect_** = AVERAGEX(Equipamento;DIVIDE([Heat_Elect_f1];[QT Arquet])) but i think it is not working correctly

Any ideas?

Thanks!

Solved! Go to Solution.

Accepted Solutions

## Re: calculate average of measures

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-12-2018 02:59 AM - edited 10-12-2018 03:00 AM

Hi Marco,

Please check out the demo in the attachment. If it isn't what you'd like, please point it out in the file.

**Please don't post sensitive data here. **

Best Regards,

Dale

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*All Replies

## Re: calculate average of measures

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-04-2018 01:29 AM

Hi @edved81,

Can you share a sample file, please? You can mask the sensitive parts first.

Since [* Avg_Heat_Elect_*] is a measure to evaluate the value over all the table, how about put it in a Card visual?

Best Regards,

Dale

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*## Re: calculate average of measures

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-04-2018 08:33 AM - edited 10-04-2018 08:35 AM

This is the original file without measures.

Each Nº certificate belongs to a Arq. type.

1º I want to count the number of times that each certificate has values with next conditions and then sum the values:

count(Fonte de Energia= Electricidade and Função 1= Aquecimento)

+

count(Fonte de Energia= Electricidade and Função 2= Aquecimento)

+

Count(Fonte de Energia= Electricidade and Função 3= Aquecimento)

2º I want to get the average of values calculated in task 1, showed by Arq. Type.

thanks!

## Re: calculate average of measures

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-09-2018 01:22 AM

## Re: calculate average of measures

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-09-2018 01:44 AM

Hi @edved81,

It's good to evaluate them one by one. But what the average should be. The total of task 1 divides by 3?

Best Regards,

Dale

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*## Re: calculate average of measures

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-09-2018 03:36 AM

Hi @v-jiascu-msft,

Imagine this example:

The Arq37 has a total of 169 lines and 55 of them have the condition 1,16 in condition 2 and 0 in condition 3

So the average will be:

for the condition 1:

- average of the 55 values will be based in the field ("Eficiencia Equipamento Função 1"), that I forgot to put in the excel file :/.

for the condition 2:

- average of the 16 values will be based in the field ("Eficiencia Equipamento Função 2"), that I forgot to put in the excel file :/.

for the condition 3:

- average of the 0 values will be based in the field ("Eficiencia Equipamento Função 3"), that I forgot to put in the excel file :/.

## Re: calculate average of measures

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-09-2018 08:12 PM

Hi @edved81,

Please correct me if the result below is wrong.

1. Do we calculate the average for each condition independently?

2. The previous step has a condition Função 1= Aquecimento. So the average for condition 1 is 55/1 = 55, for condition 2 is 16/1 = 16 and for condition 3 is 0/1 = 0. Is this right?

Can you post the steps that we can apply? Take Arp37 for an example.

Best Regards,

Dale

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*## Re: calculate average of measures

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-10-2018 02:44 AM

Hi @v-jiascu-msft,

First I want to say apologies for the confusion that I made.

I improved the file and added the resume sheet. (file edited) and now I think it will be easier to understand my question.

If you need anything else, just let me know.

thank you!

Marco

## Re: calculate average of measures

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-12-2018 02:59 AM - edited 10-12-2018 03:00 AM

Hi Marco,

Please check out the demo in the attachment. If it isn't what you'd like, please point it out in the file.

**Please don't post sensitive data here. **

Best Regards,

Dale

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*## Re: calculate average of measures

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-12-2018 03:31 AM