I am trying to make a chart that shows the average count within each quarter. I created a date table to allow me to create quarters from a date field, I can create a total count within a quarter, but I can't get it to give me an average by quarter. Is this possible within PowerPivot/Excel?
I've looked into this blog, but that utilizes SUM. Average Of Column Counting Duplicates Once - PowerPivot + DAX - Stack Overflow
Ideally, I would want to be able to leverage a splicer to select the months, and then average the count. SO if I wanted quarters, I could select my Q1-2015 field, or select months and receive AVERAGE(COUNTA()).
I've looked into this blog, but that utilizes SUM. Average Of Column Counting Duplicates Once - PowerPivot + DAX - Stack Overflow
Ideally, I would want to be able to leverage a splicer to select the months, and then average the count. SO if I wanted quarters, I could select my Q1-2015 field, or select months and receive AVERAGE(COUNTA()).
