Power BI Dax - Distinct Count and Contains String

[tsuarez]

I am trying to create a measure in Power BI where I am counting the distinct rows of one column if another column contains certain text in a string and keep getting an error.  Any assistance would be helpful.

[Arul · Accepted solution]

@tsuarez ,

try this measure,

Count of Task Name = 
CALCULATE(
    DISTINCTCOUNT('Table'[Task Name]),
    CONTAINSSTRING('Table'[Label],"Weekly"))

Thanks,

Arul

[tsuarez]

Hello,

Here is some sample data below.  The data is based on tasks activity and I want to count the unique Task Names when Labels column contains "Weekly".  I'm trying to determine the unique tasks names and what their freqnecies are.

Task Name	Label
Arkansas Children's Hospital - HCP Surveys	Quarterly;HCP Surveys
Crouse Health - Future Visibility	Weekly;Future Visibility
Internal Delivery - Influenza Vaccination Status	Weekly;Credential Data
Crouse Health - Future Visibility	Weekly;Future Visibility

[Arul · Accepted solution]

@tsuarez ,

try this measure,

Count of Task Name = 
CALCULATE(
    DISTINCTCOUNT('Table'[Task Name]),
    CONTAINSSTRING('Table'[Label],"Weekly"))

Thanks,

Arul

[tsuarez · Accepted solution]

Thank you, this was helpful.

[Arul]

@tsuarez ,

Please provide some sample data and the expected output with high level explanation of your requirement.

Thanks,

Arul