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

Compare an Individual Average against the overall Average

Hi,

 

I am trying to create a visual chart to compare an indivdual average payment against the overall average payment. In this case, in my current data I currently have an AmoutPayable column and a VetName column. I want to be able to see what the average payment is for a specific Vet and compare that against the Average across all Vets.

 

The end goal is to view this in a trend line so that I can see at what stage an Individual vet became higher than the average.

 

I have searched for this answer on the forum but as I am very new to Power BI I was unable to find the solution. Please bare my limited knowledge in mind with your responses.

 

Thank you all very much.

 

 

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi @Gavin_Shales,

 

Assume the sample data likes below: 

 

z1.PNG

 

We can create measures: 

 

AvgPerVet = CALCULATE(AVERAGE(Table1[AmoutPayable ]),FILTER(ALL(Table1),'Table1'[VetName]=MAX('Table1'[VetName])))

 

AvgAllVet = CALCULATE(AVERAGE(Table1[AmoutPayable ]),ALL(Table1))

 

Then create a line and clustered column chart below. You can see attached pbix file. 

 

z2.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi @Gavin_Shales,

 

Assume the sample data likes below: 

 

z1.PNG

 

We can create measures: 

 

AvgPerVet = CALCULATE(AVERAGE(Table1[AmoutPayable ]),FILTER(ALL(Table1),'Table1'[VetName]=MAX('Table1'[VetName])))

 

AvgAllVet = CALCULATE(AVERAGE(Table1[AmoutPayable ]),ALL(Table1))

 

Then create a line and clustered column chart below. You can see attached pbix file. 

 

z2.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors