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