One way to approach this would be to add a set for the Top 5 projects:
Then have a parameter for [Include Top Projects]
If [Include Top Projects], then include the set in the criteria. Otherwise, leave it out (and show everything regardless of set).
Thank you for your answer. I cannot figure it out.
I have the parameter:
I have a calculated field based on this parameter to generate 1 or 0 as I cannot use parameters in TOP conditions, only fields
I've created the set as you specified and added the TOP 5 field and the condition based on the calculated field above:
Now if I use the set as a filter it only displays a value when the parameter is "Yes". For "No" it displays blank.
Can you notice where my mistake is?
Enjoy your day
I think you need an additional filter:
CASE [Top Projects Only]
WHEN "Yes" THEN [Set Top 5]
Filter on true, rather than using the Set as a filter directly.
It works as expected with your add-in. Thank you both for your help.