Average

[Anonymous]

I'm looking for a way to calculate the average over time for below highlighted column:

 

The [Positive %] measure is simply Positive Count/Total Count for each month surveys were taken. Everything I've tried so far only returns 100% and I'm not sure why. Any ways of how I can get the average? I do have a separate date table as well but was unsure of how to incorporate it with this data. Thanks!

[BKirsch12]

The easiest way to do this would be to add a card and slicer to do this. Are you looking for the table to stay static? If that is true, then you'll need to create time intelligent measures for each period you want to show. Attached an example file of the easy slicer and card way.

https://drive.google.com/open?id=1QNASArWgRyKaF7DBl7IzGfAEt9Z37bxU

[Anonymous]

@BKirsch12 I was hoping to do it through DAX. The table was just meant to show the setup. Using the same dataset, I've accomplished this with another measure that was tracking something different:

 

So here the Month End column actually comes from my Date table. This works, so I attempted to do the same thing with the Positive % measure, but when I do every line comes back as 1.0 or 100%.

[BKirsch12]

I think I understand, without seeing your date table, it's tough to say exactly how to implement it. This article shows a good example of computing average over certain time frames.

https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/

[Anonymous]

@BKirsch12 Thanks! I'll be sure to check it out and give it a try.