Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
4 years ago
Solved

Count formula issue

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?
Need Help
Show and Tell
  • vjnvinod's avatar
    vjnvinod
    4 years ago

    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]))

2 Replies

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi vjnvinod ,

       

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

       

      Best Regards,

      Stephen Tao