Issue with top20 items

[Anonymous]

Hello

I will greatly appreciate if someone can help me.  

I have unit number of their forecast. I want to see also top 20 items (not a %, items). 

When I select week 10/3 I have 20 items, everything works fine. Great!

When I select week 10/10 I have 20 items, everything works fine. Great!

However, when select both week from a slicer, it gives all 40 items. I want only 20 items to be appear (whichever the forecast amount is greater).

Filter type: TOP N

Show Top 20

By value: Total Forecast

[collinq]

hi @Anonymous ,

First, thanks for the screenshot, very helpful in my thought process.

I am wondering about the connection of the Date field to the table.  Is this a Date Dim?  Is this Datefield called "Start Date" coming from the same table that you are using to rank? What happens when you put that Date Field into the table?