This content has been marked as final.
Show 1 reply
-
1. Re: Cannot add discrete measure as data source filter for live connection
Joshua Milligan Dec 21, 2016 8:51 AM (in response to Michael Damico)Michael,
This is expected. You cannot use an aggregation as a data source filter. It works for an individual view because Tableau knows the view level of detail to calculate the aggregation. But if you added it at a data source connection, then at what level would you want the sum to be calculated? Across the entire data set? In that case you'd either get all the data (because the sum of revenue wasn't 0) or you'd get none of the data (because it was 0).
If you wanted another level, then you could specify the calculation as a Level of Detail expression and it would then be available as a data source filter.
e.g. You want to exclude any department where revenue is 0:
{FIXED [Department] : SUM([Revenue])}
Hope that helps!
Joshua