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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
lg1551
Resolver II
Resolver II

RANKX Measure within Hierarchy in Paginated Report

I have a Power BI report that has a RANK measure for sales. 

The measure is used on a matrix for Managers and Sales Reps.

In the Power BI Report it applies the ranking by Managers, then if you drill down, it applies the ranking by Sales Reps.

If you show all levels, it retains the rank for the Managers and shows the ranks for the Sales Reps beneath each manager.

When I use this measure in Report Builder paginated report, it is only showing the Sales Rep level ranking.

How can I force it to retain the rank for the Manager level of the hierarchy and also show the Sales Rep level?

 

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.