Keep Zero(0) instead of (Blank) on my visual

[Anonymous]

I have taken card visual to showcase some data and I am using below query and working fine as expected but in other visual If i filtered in perticuler year it is giving (Blank). I need to keep zero instead of blank. I have tried solutions but not working for me.

Data = SUMX(FILTER('Table', 'Table'[ColomnName] = "Draft"), INT('Table'[ColomnName])) + SUMX(FILTER('Table', 'Table'[Colomn Name] = "In Process"), INT('Table'[ColomnName]))

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Have you tried just adding '+ 0' at the end of your meaure?

Data =
SUMX(
  FILTER(
    'Table',
    'Table'[ColomnName] = "Draft"
  ),
  INT('Table'[ColomnName])
) +
SUMX(
  FILTER(
    'Table',
    'Table'[Colomn Name] = "In Process"
  ),
  INT('Table'[ColomnName])
) + 0

I would recommend keeping your original measure as-is for use in tables etc. then add this one as [Data0] for use in cards etc.

Pete