March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to Solution.
When I go in today, everything seems to be working as expected. Thank you for your help with this.
When I go in today, everything seems to be working as expected. Thank you for your help with this.
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.
What field are you using to Filter?
I have a custom column Days from Today - TODAY - Date, filtering the page by that. Gets the last 60 days worth of records. It's a page filter, so it should be the same on both elements. To select the pages specifically, I am filtering by page title.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
82 | |
69 | |
53 | |
44 |
User | Count |
---|---|
202 | |
106 | |
100 | |
64 | |
56 |