Forum Discussion
Count by Measure Group
Anyone?
Hi mmyers2,
You need add [CV Cust 2] as a calculated column. Then your measure [# of SKUs2] will work. You check it out in this file: https://1drv.ms/u/s!ArTqPk2pu-BkgUKnj3Uf866VcyMS.
Best Regards!
Dale
Thank you for the reply, but a calculated column does not work as it is not dynamic.
CV Cust 2 needs to stay a measure, as it needs to recalculate as more/less customers are selected in a slicer.
Hi mmyers2,
Measures need context while your visual doesn't have one. That's why the result is always "3. Stranger". You still can select the values of many columns in a slicer when you use a calculated column. What kind of dynamic do you expect?
Best Regards!
Dale
The only way I can think of to explain it, is with an example.
Let's say item A is a "1.Runner" when looking at all customers.
When I select customers 1, 2, and 3, item A is a "2.Repeater" because the calculation is only looking at the numbers for those customers.
Then, if I select only customer 1, item A is a "3.Stranger" because the calculation is only looking at the numbers for customer 1.
We have also been trying to do this with an ABC calculation based on number of sales, but get the same issue.