I can't apply a dashboard filter to all questions that come from the same model.
Replicate
- Model from native SQL query, with two dimensions where at least one is mapped field (e.g. City and Product) and two numeric fields to use as a denominator and numerator (e.g. Shipped and Sold quantity).
- 1st question, with custom calculation
SUM([Sold]) / SUM([Shipped])
. - 2nd question, same custom calculation grouped by a dimension (Product) and filtered by the custom calculation (< 0.5) and sorted by the custom calculation.
- Add both to dashboard and add a filter on the mapped dimension (City).
- The filter can only be applied to the 1st question not the second.