1 of 1 people found this helpful
Yes. Not as straightforward as you might expect though. We don't really have a value called "All" in the data. "All" is just a convenience Tableau gives us.
But you can do a FIXED LOD that tells you how many items are in the database.
And you can do an INCLUDE LOD to tell you how many are actually on the sheet. When they match, you have selected ALL.
When you can detect a condition like this, you can use sheet swapping. Put both sheets into one container side-by-side. Put a filter on each sheet so that under one condition sheet-A will have data and sheet-B will be empty, and vice versa for the opposite condition. Then only one or the other will display on your dashboard.
So you have two parts to your question.
If this is good enough to get you going, I'm glad I could help. If you need help implementing this, upload a sample workbook so I can show you.
Thank you, Joe. I will give this a shot and let you know.