Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Count and DAX

Hi Guys, I am facing issue counting the below rows where the condition is like: Count number of rows for each group name where Open date <= Date and resolve date is >= Date. So basically the count ...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Anonymous 

unable to follow. Could you elaborate how you get 30 in your example date, say 01-01-2020?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    So the count is basically 30 since the open date is equal to Date and resolve dates are greater than Date. So count of all the tickets falling as per above criteria is 30 for that group name.