Forum Discussion

CAWizz's avatar
CAWizz
Regular Visitor
3 years ago

Weekly Average

Hello,    Any help will be extremely appreciate!   I have the following dataset made of a date column, customerID and group_class colomn with categorical datapoints for classifcation as seen belo...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi CAWizz 

 

I guess that your current value field showed as % of row total is based on the count of customerID, right? If so, you can create two measures similar to below, and add only the second measure to the matrix visual. 

Measure = DIVIDE(COUNT('Table (2)'[customer]),CALCULATE(COUNT('Table (2)'[customer]),ALLSELECTED('Table (2)'[category])))
Measure 2 = IF(ISFILTERED('Table (2)'[date]),[Measure],AVERAGEX(VALUES('Table (2)'[date]),[Measure]))

Then in the formatting pane, go to Column subtotals and change the Subtotal label to "Average of daily %". 

You will get the following matrix finally. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.