Hi!

Unfortunately, this is due to an annoying quirk of how Looker Studio works. The report level filters are handled after the query data is obtained, so it filters out the rest and then sums the remaining items.

However, Reach is configured to disallow summing to keep data integrity (the why is explained in this article). So that 0 value in the scorecard and summary row are actually hiding the error “Can’t be calculated, would require summing deduplicated values”.

Please see our known issue about this for more information and possible workarounds:

https://support.supermetrics.com/support/solutions/articles/19000103265-how-to-fix-null-no-data-na-values-from-unique-metrics-in-looker-studio