Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
104 | |
69 | |
48 | |
41 | |
34 |
User | Count |
---|---|
164 | |
112 | |
62 | |
54 | |
38 |