Forum Discussion

JCuoco's avatar
JCuoco
Regular Visitor
4 years ago
Solved

Distinct Count one column with Contained Strings from another

Team, I would like to do a distinct count on a column (Total Encounters) but only count the encounters that also have the value of "No Show" in a separate column  Thanks, James 
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi JCuoco 

     

    You need to use Calculation with filter:

     

    If you want to filter the table to show the rows which have "No Show" in a seperate column:

    Measure = 
    Calculate(DISTINCTCOUNT(table[Total Encounters]),Filter(table,table[separate column]="No Show"))

    If "No Show" is part of the values of data in seperate column, use ValtteriN solution.

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi JCuoco 

 

You need to use Calculation with filter:

 

If you want to filter the table to show the rows which have "No Show" in a seperate column:

Measure = 
Calculate(DISTINCTCOUNT(table[Total Encounters]),Filter(table,table[separate column]="No Show"))

If "No Show" is part of the values of data in seperate column, use ValtteriN solution.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 

 

JCuoco's avatar
JCuoco
Regular Visitor
4 years ago

VahidDM thank you! This is absolutely perfect! love it! i did the "LONG" way last night and got the same number, so i know it is correct! THANK YOU