I need to count distinct occurrences into a dataset which meet three conditions.
Until now I've tried with something like follows:
=COUNT(DISTINCT(IF(condition_1 = True AND condition_2 = True AND condition_3 = True, row)))
While it worked perfectly using just two conditions, it is when I add the third one that, even if the expression editor doesn't show any warning message, the output I get is entirely wrong when I check it on my data warehouse.
How should I tweak the expression so it gives me a correct output?