Static Measure value which doesn't change based on the selection of other widget

[Anonymous]

Hello All,

I am showing data on Line and Stack column chart. I would like to have my Line static regardless of the filters changed on the report page. I am attaching sample data for understanding.

Transaction Details
Store ID	Trx Id	Weekday
952	501	Monday
953	502	Tuesday
954	503	Wednesday
955	504	Thursday
952	505	Friday
953	506	Saturday
954	507	Sunday
955	508	Monday
952	509	Tuesday
953	510	Wednesday
954	511	Thursday

Sales Master
	Store ID	SECount
	952	50
	953	20
	954	17
	955	45

Data on the Widget
Store Id	Total Sales	SE Count	Average per Salesexec
952	3	50	0.06
953	3	20	0.15
954	3	17	0.18
955	2	45	0.04

Measure Formula

Average per Sales exec = DIVIDE( COUNTA('Transaction Details'[Trx_ID]),CALCULATE(Max(SalesMaster[SECount]))

Widget on the Report

I want the Black Line viz my Measure Average per Sales Exec to be static. It gets changed if I changed my store selection from the filter. Basically, I want to compare the Global average of sales executives against individual stores but based on the weekday. I am getting the data correct on default selection of all stores but as soon as I select selected store the Blackline also changes. 

Any help from the community will be helpful.

Thanks,
J

[Nathaniel_C]

Average per Sales exec = DIVIDE( COUNTA('Transaction Details'[Trx_ID]),CALCULATE(Max(SalesMaster[SECount]),ALL(SalesMaster))

Hi @Anonymous ,

Try ALL()
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous]

Hi @Nathaniel_C 

Thanks for your help. I have tried using ALL function and it didn't work. Let me know if you think of any other option.

Regards,
J

---

@Nathaniel_C wrote:

Average per Sales exec = DIVIDE( COUNTA('Transaction Details'[Trx_ID]),CALCULATE(Max(SalesMaster[SECount]),ALL(SalesMaster))

Hi @Anonymous ,

Try ALL()
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

---