Display static measure and dynamic measure in single chart

[Tevon713]

Hi all,

I have a visual which have filters on region, site and also time period.  All 3 below are measures, with exception the region avg measure change due to region filter and national average is static regardless. 

I want to display a single bar for the region and national averages and not having it show on all every data measure. What is the optimal best solution? Is that even possible? Even if I manually manipulate to find the average not feasible in long term solution.

Below is the link for the sample file. 

https://www.dropbox.com/s/snkz368ww4smoq6/Find%20average%20of%20measure.pbix?dl=0

[TomMartens]

Hey @Tevon713 ,

please take the time and create a pbix file that contains some sample data, but still reflects your data model (tables, relationships, calculated columns, and measures.) Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method share the xlsx as well. Describe the expected result based on the sample data you provide.

Please create a simple scribble of the clustered chart you want to create, based on the sample data you provide.

Regards,

Tom

[Tevon713]

Thanks @TomMartens. Sorry I forgot to share the data source and file.

Below is the link for the sample file. 

https://www.dropbox.com/s/snkz368ww4smoq6/Find%20average%20of%20measure.pbix?dl=0