cancel
Showing results for
Did you mean:
Regular Visitor

## Calculating Averages dependent on Aggregation

Hi All,

I have a scenario where I need to calculate the "% of Projects that meet our Customer Satisfaction Score" of >=5 and show the result in a Card Visual.

The lowest granular level of information is Respondent.

As you can have multiple Respondents per each Project, I first need to calculate the Average Score Per Each Project.

For instance "Facebook Project" average  = (4+7)/2 = 5.5 =Meets Satisfaction Score

I then need to formulate:

CountIF( (Average of Project)>=5))

Count of All Projects

Is there an easy way to do this.

I have tried SumX and Summarize functions but to no avail.

Appreciate any help.

Thanks,

Brian

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Calculating Averages dependent on Aggregation

I would just copy your query, strip out all other columns other than Project column, remove duplicates and you'd have a Projects table in 5 minutes.

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

3 REPLIES 3
Highlighted
Super User

## Re: Calculating Averages dependent on Aggregation

https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Regular Visitor

## Re: Calculating Averages dependent on Aggregation

Hi and thank you for the reply.

However, how can I calculated this, without having to create a "Projects Table" first?

Or is there a way?

Regards,

Brian.

Super User

## Re: Calculating Averages dependent on Aggregation

I would just copy your query, strip out all other columns other than Project column, remove duplicates and you'd have a Projects table in 5 minutes.

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Announcements

#### Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)