Forum Discussion

adgarza's avatar
adgarza
Frequent Visitor
9 years ago

Top 10% with filter

I have a spreadsheet of work order information.

I want to pull the top 10% of work orders based on some slicers I created.

 

I created the following measures to display rank and percentile rank.  I can filter to the top 10 work orders based on rank, but if i try to to filter by percentile rank, I don't get the desired output.

 

Rank = RANKX(ALLSELECTED(womaster),CALCULATE(SUM(womaster[WOtotal])))
Pct Rank = [Rank] / COUNTROWS(ALLSELECTED(womaster))

 

If i put on a slicer for all work orders from a certail category, I get the appropriate rank and percentile rank displayed for every value in the table, but once i filter to top 10%, I get more rows than is appropriate.  For example,  with no filter, there are 50 work orders in the top 10 percent, but when I apply the filter, i get 96 work orders.  To be clear, the problem isn't with the slicer - the problem is the filter.  

 

Any one have any ideas how i can fix this?

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    adgarza,

     

    Could you please share us more detail infromation, if possible share us your PBIX file, so that we can make further analysis.

     

    Regards,

    Charlie Liao