I have tried but I honestly don't think its possible. Not with that setup... I think Tableau needs something to filter on and a COUNTD is not that.
Sorry, maybee someone else knows better.
Thanks for your reply. If sheet 1 is not a measure. It's a category dimension with a measure data, how to do that? Importantly, I don't know how to set up filter action that when it's open, no data on sheet 2, only when click a category dimension in sheet one, the data will show in sheet 2.
Go to dashboard actions and set up a filter. Be sure to check:
This means that the second dashboard will be empty every time the filter is "unclicked".
This will do the trick!
Please like and mark as helpful if this solves the problem (or if you find it helpful). That would mean a lot to me (and others).
Br / T