cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brianoreilly Regular Visitor
Regular Visitor

Calculating Averages dependent on Aggregation

Survey Sample Set.JPG

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Highlighted
Super User
Super User

Re: Calculating Averages dependent on Aggregation

It seems like this article presents a very similar scenario:

 

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

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Brianoreilly Regular Visitor
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
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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

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

Difinity Conference

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

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)