I am joining 2 tables. When I am filtering the data in table, I am getting correct unique count of concatenated value but when I am applying the same filters in ScoreCard, I am not getting the correct result even after applying COUNT DISTINCT in the metric.