How to display Top 10 rows in a table visual after filtering by a visual filter
I need to display Top 10 values in a table visual where: (1) the rows are filtered by a visual filter with a complex measure "IncludeInTable"
(2) and then display the top 10 rows from that filtered set.
This is what I'm trying.
The problem is that it's doing the reverse. The table is first applying the Top N filter and then applying the visual filter for IncludeInTable. As a result, only those rows in the top 10 rows for which IncludeInTable evaluates to 1 are being displayed.
How do I achieve the desired result? Your help is most appreciated.
Your suggestion lead me to the solution. I modified my Ranking measure to wrap the RankX inside a calculate which runs the ranking over a filter that only includes either "Lost", or "Bound" or "Quoted" etc.