cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

average by filtering doesnt work

Dear Community,

 

I dont understand why the average doesnt work when I use  filter: For example: if I choose a sell team I get the right percentage of sells but if I choose 2 sells team I dont get the right avarege between those two.

 

Any Advice?????

 

In the first picture The 76.62% should be 79,44% considering those two sells team (101-104)

 

 

 

WhatsApp Image 2018-08-16 at 12.47.38.jpegWhatsApp Image 2018-08-16 at 12.47.00.jpegWhatsApp Image 2018-08-16 at 12.46.23.jpeg

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: average by filtering doesnt work

It’s most likely due to the way Power BI filters first, then calculates. Eg

 

team A has 3 records

5,6,7 = avg of 6

 

team B has 6 records

10,12,10,20,18,20 = avg 15

 

avg across both teams = 10.5

 

but Power BI will add the total (108) divided by 9 = 12

 

you can solve it with averagex

 

=AVERAGEX(values(table[team]),[your measure]]



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
2 REPLIES 2
Super User
Super User

Re: average by filtering doesnt work

It’s most likely due to the way Power BI filters first, then calculates. Eg

 

team A has 3 records

5,6,7 = avg of 6

 

team B has 6 records

10,12,10,20,18,20 = avg 15

 

avg across both teams = 10.5

 

but Power BI will add the total (108) divided by 9 = 12

 

you can solve it with averagex

 

=AVERAGEX(values(table[team]),[your measure]]



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted

Re: average by filtering doesnt work

Thank you @MattAllington

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 409 members 4,338 guests
Please welcome our newest community members: