Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power BI Dax - Distinct Count and Contains String

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...
Need Help
  • Arul's avatar
    Arul
    3 years ago

    Anonymous ,

    try this measure,

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

    Thanks,

    Arul

  • Anonymous's avatar
    Anonymous
    3 years ago

    Thank you, this was helpful.

Arul's avatar
Arul
Super User
3 years ago

Anonymous ,

try this measure,

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

Thanks,

Arul

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you, this was helpful.