Forum Discussion

PhotoBiker's avatar
PhotoBiker
Icon for Advocate I rankAdvocate I
8 years ago
Solved

DISTINCTCOUNT with filters

  Hi,   I'm trying to get a DISTINCTCOUNT after I filtered a table. In the table below, I'm only interested in the records where Answer = Yes. Then, I want to count the distinct clients.    ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey PhotoBiker,

     

    I tried your code and it worked for me. I got a "Clients who Answered Yes" of 1 for all of the specific filters, and 2 if no filters were selected. Did you create a measure or a calculated column? A measure should produce the proper output while a calculated column would behave the way you are describing.

     

    Thanks,

    Parker

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi. 

I have similar situation. Scenario:

Table A: 

1. Employee Name-column

 

Table B:

1. Country

 

Objective: Count distinct Employee Name by Germany and France- ONLY. 

 

  • Below is what I have done.
Measure = calculate(DISTINCTCOUNT('tABLE A'[Employee Name]; FILTER('Table B';'Table B (2)'[Country]="Germany" && Table B (2)'[Country]="France.
  • Error: Too many arguments passed to DISTINCTCOUNT function.Maximum argument count for the function is 1. 
Can anyone help define the write function?
 
Thank you in advance. 
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey Anonymous 

Could you try this code?

 

Measure =

   CALCULATE(

     DISTINCTCOUNT('tABLE A'[Employee Name]);

     FILTER('Table B';'Table B (2)'[Country]="Germany" && 'Table B (2)'[Country]="France")

)

 

 

I added an extra ' to Table B (2) and " to France. And also some closing brackets.

  • Jsummers's avatar
    Jsummers
    Icon for Helper I rankHelper I
    2 years ago

    Thank you, I have just used this and it worked great 🙂