Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
rkasper516
Regular Visitor

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

Top10 Table.png

Specific Pages with 1 Rank Included

Top10 and Filtered - Good.png

 

Filtered Visual with 1 excluded

Top10 and Filtered - Bad.png

1 ACCEPTED SOLUTION
rkasper516
Regular Visitor

When I go in today, everything seems to be working as expected. Thank you for your help with this. 

View solution in original post

5 REPLIES 5
rkasper516
Regular Visitor

When I go in today, everything seems to be working as expected. Thank you for your help with this. 

Sean
Community Champion
Community Champion

@rkasper516 

 

Try - ALLSELECTED('Pageview Data')

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
Community Champion
Community Champion

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.