Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Count Text Values, but return ) not (Blank) - Power BI

Hi Folks I created a measure to count how many Overdue projects appear in a list Overdue Count = CALCULATE( COUNTROWS( 'Project Overview'), 'Project Overview'[Overdue Flag] = "Overdue") I ...
Need Help
  • edhans's avatar
    edhans
    3 years ago

    Wrap your function with COALESCE.

    So COALESCE([Your Measure], 0)

    COALESCE returns the first non-blank value, so if Your Measure is blank, it will default to the 0.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Perfect Solution



Thank You!