Forum Discussion

mmyers2's avatar
mmyers2
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]...
Need Help
mmyers2's avatar
mmyers2
Advocate I
8 years ago

I tried the simplified weekly average, and it did not summerize correctly. I need the measure to summarize based on customer, product, and week, regardless of what I use it.

 

When I use the formula for a visual, here is what I get, which is not correct. This is what I get no matter what formula I use. 

 

 

Surely there has to be a way to count records based on dynamic categories. 

 

Here is an example of how it should look. I used static data in a table to create this, but I need it to be dynamic.

 

 

mmyers2's avatar
mmyers2
Advocate I
8 years ago

Here is a link to a sample of the model.

 

I really need to get this working.

 

Dropbox Link

  • mmyers2's avatar
    mmyers2
    Advocate I
    8 years ago

    Anyone?

      • mmyers2's avatar
        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.