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() )