Count formula issue

[vjnvinod]

Hi Experts

this is my current measure, which appears to be working fine

Current HCount = CALCULATE( COUNTA('Current HC'[GPN]),FILTER(ALL('Date'),'Date'[Date]<=[LastSelectedDate]))

now the date table is connected to the Current HC table which has Blank dates or empty dates

this formula is considering that also when counting the number of resources

how do i correct the above formula, so it ignores the blank Dates from the Current HC table?

[vjnvinod · Accepted solution]

please ignore I found the solution

Current HCount = CALCULATE( COUNTA('Current HC'[GPN]),'Current HC'[Office Joining Date]<>BLANK(),FILTER(ALL('Date'),'Date'[Date]<=[LastSelectedDate]))

[Anonymous]

Hi @vjnvinod ,

Glad you solved the problem yourself, you can mark the reply as the solution, more people will benfit.

Best Regards,

Stephen Tao