Count calculation issue

[Anonymous]

i have table like this ....I want to calculate count for type New with endt=0.So,i created a measure as 

CALCULATE(COUNT('Table'[type]),'Table'[endt]=0). Issue is After calculating count output is getting 3 instead of 2.

So, i think count calculating blank values as zero...I want to avoid blank values calcualtion...Is it possible?

[Tahreem24]

@Anonymous  try this measure:

New  MEASURE= CALCULATE(COUNT(Table[Type]),ISBLANK(Table[endt])=FALSE(),Table[endt]=0)

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

BLANK is treated as 0 in this situation so you will need to adjust your measure to

CALCULATE(COUNT('Table'[type]),'Table'[endt]=0 && NOT(ISBLANK('Table'[endt])))

Regards

Phil