Sum of Rankx measure

[nicq10]

Overall objective:

I am bringing in pageview data from Google Analytics for a given property. Based on the data, I want to be able spot trends in the relative rise or drop in popularity of various pages over any given period of time.

What I have so far:

To start, I have a measure ("Daily Rank") which calculates a page's rank relative to all other pages for a given day, based on the number of pageviews each page received. Here's a mockup of what that data looks like when added to a visual:

I have been able to get to this point using the RANKX function like this:

Daily Rank = 
     Rankx(
          ALL('All Websites - Pageviews'[Page]),
          [Total Current Pageviews]
)

Where [Total Current Pageviews] is defined as:

Total Current Pageviews = sum([Pageviews])

Now I want to do a few more things:

1. Get a sum of each page's Daily Rank for whatever date period is being viewed. In the example above, that sum would be 72.
2. Get an average of each page's daily rank for whatever date period is being viewed. In the example above, that average would be 14.4.
3. Get the variance (difference) of daily rank from the average for each row
4. Get the %variance of the daily rank from the average for each row

If I were to pull all this into a visual, I would expect it to look something like the following:

My Question(s):

1. What would the Dax formula look like for the "Cumulative Page Rank" measure?
2. Is this a case where the "Daily Rank" measure actually needs to be calculated column instead?

My assumption here is that once I figure out what that "Cumulative Page Rank" formula should look like, the formula for the "Average Page Rank will follow the same general pattern.

[Greg_Deckler]

This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149