Forum Discussion
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
3 Replies
v-ljerr-msftMicrosoft Employee
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. :smileyhappy:
Regards
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
