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

How to create a new measure using slicer data

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 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-ljerr-msft
Microsoft

Re: How to create a new measure using slicer data

Hi @DaveC123,

 

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

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

r6.PNG

 

Regards

View solution in original post

3 REPLIES 3
Microsoft v-ljerr-msft
Microsoft

Re: How to create a new measure using slicer data

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. Smiley Happy

 

Regards

DaveC123
Frequent Visitor

Re: How to create a new measure using slicer data

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

 

 

 

Microsoft v-ljerr-msft
Microsoft

Re: How to create a new measure using slicer data

Hi @DaveC123,

 

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

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

r6.PNG

 

Regards

View solution in original post

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.

Top Solution Authors
Top Kudoed Authors