1 of 1 people found this helpful
You should change your calcaulation a bit as :
IF [Group]='A' THEN [Client] ELSE NULL END
Use NULL instead of 0. When you put 0 then for group B records it takes as 0 and that counts 1 extra record.
I think the idea is to get the distinct count of clients. In your approach if a particular client record is multiple times, It will be counted that number of times which might give wrong result.
I'm not aware of the actual data set however if you see the sample data you won't find any multiple entry against any client. I just tried to fix existing calculation.
Thank you! Your solution is exactly what I needed.
Thank you!. Your solution works fine when the database has unique records as in the example.
I forgot to mention that in the project I'm working on I have several records in the client dimension.