Forum Discussion

safsad's avatar
safsad
Icon for Helper I rankHelper I
5 years ago
Solved

How to find total hours without affecting the date selection?

Hi ,   I want to find the Sum of Hours from the Hours table, so what i'm looking for is to show the sum of Actual hours as i marked in the screen shot, but without the date filter.  The date sectio...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    safsad , Do you need without any filter? Try

    calculate(SUM(hrs[hrs]), all(Hrs))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

safsad , Do you need without any filter? Try

calculate(SUM(hrs[hrs]), all(Hrs))

safsad's avatar
safsad
Icon for Helper I rankHelper I
5 years ago

Thanks Amit for the solution. 

 

I got it by  the following formula :

 

CALCULATE(SUM(hrs[hrs]),ALL(hrs[ddate]))