Forum Discussion

Advocate I

8 years ago

Count by Measure Group

I have a simple table with customer/SKU level sales data by week. I have two measures: Cust Avg Qty/Wkly = AVERAGEX(SUMMARIZE('Cust Usage','CUST Usage'[CUST_ID], 'CUST Usage'[PRODUCT_NUMBER]...

Advocate I

8 years ago

Here is a link to a sample of the model.

I really need to get this working.

Advocate I

8 years ago

Anyone?

v-jiascu-msft
Microsoft Employee
8 years ago
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
- mmyers2
  Advocate I
  8 years ago
  v-jiascu-msft
  
  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.
  - v-jiascu-msft
    Microsoft Employee
    8 years ago
    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