How to create a new measure using slicer data

[DaveC123]

I am using a slicer, so when I click on one customer in the splicer the "Tachometer" visual displays the average CpM (average Case per Minute).   But actually I am looking at displaying the goal 10% above the Max average CpM and another 10% below the Average CpM to display a range.  This needs to change for each different customer I click on in the splicer.  So I understand I need to create 2 new measures one for the goal and one for the lower number:  

Goal = (Max of Avg CpM) + (Max of Avg CpM * .1) 

Min = (Avg CpM) - (Avg CpM * .1)

Thanks 

[v-ljerr-msft]

Hi @DaveC123,

Could you post your table structures with some sample data, and your expected result? So that we can better assist on this issue. 

Regards

[DaveC123]

Sorry about not posting the data.  Here is an example:

Month	         Customers	QTY	Minutes	Avg CpM
4/1/2016	Customer A	46,579	30,794	1.5
4/1/2016	Customer B	5,349	5,820	0.9
5/1/2016	Customer A	34,349	15,880	2.2
5/1/2016	Customer B	5,369	1,659	3.2
6/1/2016	Customer A	54,235	26,118	2.1
6/1/2016	Customer B	4,487	1,428	3.1
7/1/2016	Customer A	45,450	18,242	2.5
7/1/2016	Customer B	4,881	1,007	4.8
8/1/2016	Customer A	52,952	24,127	2.2
8/1/2016	Customer B	3,658	603	6.1
				
				
	Goal should be	Customer A =	2.75	
	Goal should be	Customer B =	6.71	
				
	Min should be 	Customer A =	2.25	
	Min should be 	Customer B =	5.49	

In thew Value Fields I can choose "Max of Avg CpM" but I can not seem to add it on the DAX, correctly.

New Measure = Sum('Customer Indvl Data'[Avg CpM]*.1)+'Customer Indvl Data'[Avg CpM])

THank you,

DaveC123

[v-ljerr-msft · Accepted solution]

Hi @DaveC123,

You can use MAX function to get "Max of Avg CpM". The formulas below are for your reference. 

Goal = MAX('Customer Indvl Data'[Avg CpM])*1.1

Min = MAX('Customer Indvl Data'[Avg CpM])*0.9

Regards