If you change the calculation in the filter to be something more along the lines of:
IF CONTAINS([Match],[Parameter]) = "True" THEN "True" ELSE "False" END
This will only pull through records that contain the searched parameter in the Match field regardless of whether they are home or away.
Let me know if this doesn't resolve your issue.
so first you have to create parameter and add values from fields Home and Away, so you have all combinations.
The formula for search is:
CONTAINS(Match,Parameter) and put that calc in filter shelf and choose TRUE. It is case sensitive.
Hi Charlie.. this sounds good.
I will try it and let you know if this works =)
Hi Hrvoje and Charlie,
Those solutions works great. =) Thank you for your help. But one problem pops up.
After I add values from fields Home and Away to parameter it is static. The thing is that
I have other filters on my dashboard and sometimes on my table are 10 clubs. But
this parameter shows 39 clubs always. is there a way to dynamically change
parameter or to have option that filters influence parameter?
by default parameters are static and cannot be cascading (dynamic). There are some solutions like this one: The Vizioneer: Clickable Drillable Cascading Dynamic Parameters in Tableau but I find that complicated. Maybe there is a way using JS, but that is another pair of shoes.
I will read this article in the evening. If I manage to do something with this I will make tutorial here.. =)
Hvala za link...