Re: Calculate Average of a Measure

BIBryan — Tue, 12 Apr 2016 03:09:57 GMT

Greg_Deckler --thank you. I've tried that. I get the error: "The AVERAGE function only accepts a column reference as an argument."

Hmmm...

Calculate Average of a Measure

BIBryan — Tue, 12 Apr 2016 00:11:46 GMT

I'm measuring video views on a web page. I pull a total every few days. My data table has a list of video titles, and calculates the number of new views based on the new total minus the previous total. For each row there is a "report date".

In Power BI, I was able to use DAX to create a measure called "Duration" that uses the DATEDIFF formula to calculate the number of days from when the video launched to the last report date.

Duration = (DATEDIFF(min(MasterData[Report Date]),MAX(MasterData[Report Date]),DAY))

I apply a filter to the table to pull out the dates when views were below a certain threshhold. Everything looks good up to this point. I get a list that diplays the title of the video in one column and the duration of each after the low-outliers are filtered out. All I want is an average of this second column. But because it is a measure, I can't figure out how to calculate it.

My primary objective in all of this is to determine the most vigorous lifespan of a video once it is launched. That is, there is a period of time when the video is hot, and then it is a mere trickle the remaining time. I want to know the average hot span for video views--that is, how many days is a video hot for on average?

Thanks in advance!

BIBryan Tracker

Re: Calculate Average of a Measure

Calculate Average of a Measure