There are two tables, each with a unique ID labeled as ID1 and ID2. As part of data preprocessing, I created an integrated table consisting of paired unique IDs and associated information columns.
In Looker Studio, I am interested in the unique counts of each ID when filters are applied based on the related information, and these counts are displayed using a scorecard. When no filters are applied, the scorecard functions correctly and displays the numbers.
However, when multiple filters are applied to a single item, the unique counts of IDs increase compared to when no filters are applied. Upon investigation, it appears that a unique count is performed for each filtered item, and their total is displayed. Is this behavior normal, and how can I perform a unique count with multiple filters?
LinkedIn
Twitter
