cancel
Showing results for
Did you mean:
Highlighted
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

## 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.

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

Regards

3 REPLIES 3
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.

Regards

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

## 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.

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

Regards

Announcements

#### 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!

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

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