It could be done with the help of LOD (Level-Of-Detail) expressions.
First, one would calculate a distinct count of Ingredients per each Product.
This could be done using FIXED LOD, so the result is the same for all rows
where Product is the same, and it is independent on Filters on a view
(unless they are the Context ones, which is not the case here).
Then on a view this value is compared to the actual # Ingredients shown.
This actual value could be calculated using an EXCLUDE LOD.
When filtering out some Ingredients, the latter is less then the former --
only for those Products which Ingredients are filtered out.
You're using Tableau version 9.1
So please find the attached wb version 9.1
Hope it could help a bit.
Ingredient filter problem_YF.twbx 105.2 KB
Thank you very much. That worked indeed!
I still had a little problem what was caused by my two blended data sources. Apparently this trick can only be done in the primary data source. So after switching the primary datasource, it works. (:
Thanks a bunch for your help.
Have a good day!
Justin, you're welcome.