It's not possible to create a dashboard filter using formulas. I could create a dashboard filter only with variables that are present in a data source. I am able to create a value in pivot table an...
Not sure I'm following the use case, so may need more detail, but here's an example. The dashboard is filtered to only Brands with a Total Quantity > 0. The left widget ignores the dashboard filter for context of what's being removed by the dashboard filter in the right widget.
We tried this and it WORKS great! Thanks for sharing.
The only downside it that once the filter is defined, the formula can´t be changed (e.g. if the user would want to change the value in the formula).