Forum Discussion
RANK measure different in different visuals
I have a dataset of website traffic by date and page name. To display the top visited pages I created a Measure [Rank] to sum up the total pageviews for each page.
TotalPageviews = SUM('Pageview Data'[Unique Pageviews])
Rank = RANKX(
GROUPBY(
ALL('Pageview Data'),'Pageview Data'[Page Title])
,[TotalPageviews])
When I do not filter the Page Title, everything works great. This is how I am displaying the top 10 pages. I also wanted to be able to the rank of a few specific pages. When I create that visual, the rank is off by 1. It is correct if I add the top ranked page to the filter.
Top 10 Visual
Specific Pages with 1 Rank Included
Filtered Visual with 1 excluded
When I go in today, everything seems to be working as expected. Thank you for your help with this.
5 Replies
SeanCommunity Champion
That doesn't work. That will rank the smaller group 1,2,3.
What I am looking for is to get the overall ranking of specific pages. In the lower chart. In the pictures, Health Information Management (HIM) Outsourcing | MRA should be 10 in both.
- Sean
What field are you using to Filter?
When I go in today, everything seems to be working as expected. Thank you for your help with this.