Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |