Reply
Highlighted
New Member
Posts: 2
Registered: ‎02-09-2017

Built In Top N Visual Level Filters don't work with Measures

I've searched and found nothing, so apologies that my first post is an issue/question.  The built-in Top N filter feature works fine for non-calculated columns/measures, but whenever I try to do a top N filter for a measure, I get results of practically the whole list vs. just the top 5 or 10 I want in the visual.  I know I could be using Rank X and other formulas, but honestly, this is a poor solution, something that Tableau solved a while ago.

 

In the example below, I only want the top 5 stores for Sales $'s/Transaction.  The Sales/Trans is a measure of the formula Sum(Sales $'s)/Sum(Transactions).

 

Here's what happens, clearly it's more than the top 52017-02-09 08_45_05-Weekly Trade GRv2 - Power BI Desktop.png2017-02-09 08_44_45-Weekly Trade GRv2 - Power BI Desktop.png:

 

 

 

Super Contributor
Posts: 4,721
Registered: ‎07-08-2016

Re: Built In Top N Visual Level Filters don't work with Measures

@bigmacfu

 

I tested with a similar sample as below but cannot repro the same issue. Could you please provide your PBIX file or some sample data to me? I can take a look to see if there are some wrong configurations.

 

Built In Top N Visual Level Filters don't work with Measures_1.jpg

 

Best Regards,

Herbert