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

Create table / view that shows an additional row of aggregated data

Hi

 

I am hoping someone can help me

 

I would like to compare an employees career history against the average of all employees in a single table. Where the average does not include the employees months if they are still in that role

 

I therefore need to show the number of months in each role within the organisation.  So for example 

 

                           Role 1          Role 2     Role 3

Employee A         4                 5              6

Employee B          10              11

Average                 7                5

 

The Average for role 2 is 5 as the 11 months for employee B is not included in the total as they are still active in this role. 

I have calculated the average row using AVERAGEX

However I now want to display in a single table the employees filtered together with the average line.  So for example I would want to show Employee A and the average or Employee B and the average only. 

 

How do I do this?

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
amitchandak Super Contributor
Super Contributor

Re: Create table / view that shows an additional row of aggregated data

refer

https://community.powerbi.com/t5/Desktop/Calculate-Average-per-category/td-p/362637

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

View solution in original post

1 REPLY 1
amitchandak Super Contributor
Super Contributor

Re: Create table / view that shows an additional row of aggregated data

refer

https://community.powerbi.com/t5/Desktop/Calculate-Average-per-category/td-p/362637

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

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)