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

adjust an average

Hello,

 

I am not sure if I am going to explain this correctly or not, but I am looking for a way to adjust a rolled up average. My current graph has a drill down/drill up. When you drill up it gives the overall average for each domain. The domains are made out of questions. Each average is for each question across 19 sites. When rolled up into the domains it is taking the average of the questions that fall under that domain. My issue is the first two years of the data there was only 4 questions for a specific domain but the last two years we have added 3 extra questions and now for the previous two year (2016,2017) the average is not calculating correctly because it is going off the additional questions added. I am not sure how to fix this. I need 2016, 2017 to be divided by 4 questions for the average and 2018,2019 to be divided by 7 for the average.

 

I really hope this makes sense.

 

TIA

2 REPLIES 2
Community Support
Community Support

Re: adjust an average

@jjasper ,

 

Could you share more details about your requirement and give some sample data?

 

Regards,

Jimmy Tao

jjasper
Frequent Visitor

Re: adjust an average

@v-yuta-msft 

 

I have a table that has data that has Village, Domain, Question and Average. So each questions falls under a domain and then those domains are rolled up via PowerBi. What is currently happening is we switched to a new survey in 2018 and now there is more questions added to a specific domain. What it looks like Power Bi is doing is it is taking all the questions in that domain and averaging them. But for 2016 and 2017 there is only 4 questions in the domain vs. 2018 and 2019 where there is 7 questions in the domain. 

 

What I would like to do is for 2016 and 2017 average the domain average by only 4 qeustions and for 2018 and 2019 average the domain by 7 questions. When I roll up to the domains it is throwing my averages off because it is dividing by more questions then it needs to. 

 

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors