cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rlansing
Resolver I
Resolver I

Page Level Filter rejecting placement of RANK measure

Hello,

I am trying to place my measure that calculates item ranking into the "Page Level Filters" field so that I can filter the entire page to the top 15 Brands of a specific category of sales data. When I drag and drop the measure into the field, it does not stay there. It seems to reject the measure. I assume this is user error due to the contextual nature of the measure, but I would really like to filter by rank, how can I do it?

 

Here is how the measure is written:

$ Vol Rank = IF(SUM( 'DATA'[$ Vol] ) > 0, RANKX ( ALLSELECTED( 'DATA'[Brand] ), CALCULATE(SUM( 'DATA'[$ Vol] ), ALLEXCEPT( 'DATA', 'DATA'[Market], 'DATA'[Brand] ))), BLANK() )

 

Thank you,

Bobby

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Measures can't be used in slicers or page filters. Would need to create a calc column (or a measure that returns only top 15)

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Measures can't be used in slicers or page filters. Would need to create a calc column (or a measure that returns only top 15)

I am not able to create a calculated column using RANKX. Can you tell me exactly what work around I used to restrict my rank meanure below to top 5 in the entire page :

RankManuSales = RANKX(ALL(Manufacturers[Manufacturer]),[Total Sales], , desc)
Evogelpohl
Helper V
Helper V

My RANKX is far easier and I cannot use it as a filter at the report level or the page level.

 

Item Folder Rank = RANKX(all('Execution Log'[Item Folder]),'Execution Log'[Executions],,,Dense)

 

I want my entire report to be limited to only <=10 as this measure calculates.  Essentially an analysis on the "Top 10".

 

What gives?

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.