How to count Distinct values based on 2 different column values in a SSRS report?

(0) Share

Report

Posted on by Community Member

Hello Experts,

Sorry for off the topic post, however I could not find any community forum related to SSRS.

I have a question around Counting number of New Accounts based on Distinct Account values, I'm using grouping condition to list all the Accounts and in another column I'm listing whether it is a New or Old account using an expression. But however when I try to count the number number of new Account it is counting all the rows that have a value of "New" but I want to count all the distinct New Accounts. Is there any way that I can do that.

NOTE: "New/Old Account" column is not in my database but I'm getting that value based on another condition/expression.

Here in the screenshot below, Count of New Accounts should be 2 instead of 3 since there are only 2 new accounts.

66057.1.png