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

Creating an average which does not change when filtering

Hi All,

 

I'm still somewhat of a novice, but I am struggling with a measure which doesn't change when filtering. the average line needs to relate to months and years so I can create a visual which show performance against the regional average. I managed to create this in Excel quite quickly but have hit a dead end in Bi.

 

The dataset I have is 2014>present

Units / Date / Month / Year

 

Everything I have tried so far has come out of a straight line and changes to the average of my selection.

 

 

Thanks in advance for your help.

 

Below is an image of what I expect the final outcome to be.

2019-07-04 16_15_05-Power BI Desktop.pngApologies for the crudeness

2 REPLIES 2
Super User
Super User

Re: Creating an average which does not change when filtering

Hey,

 

can you please provide a simple example with some data, I'm not sure what you mean by regional.

 

Regards,

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
IO_Rosco Frequent Visitor
Frequent Visitor

Re: Creating an average which does not change when filtering

Hi Tom

 

Thanks for getting back to me here is the Link to Data

 

This includes the regions across EMEA so essentially the average line needs to keep referencing the entire region whilst being able to select a region (orange line on the original post) to see how its performing versus the regional average.

 

I hope that makes sense.

 

 

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 106 members 1,673 guests
Please welcome our newest community members: