How to find total hours without affecting the date selection?

[safsad]

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 section shouldn't affect the "Actual Hours".

 I really apprecaite any help provided.

This is the formula i used:   

Actual Hours = SUM(hrs[hrs])+0

[amitchandak · Accepted solution]

@safsad , Do you need without any filter? Try

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

[safsad]

Thanks Amit for the solution. 

I got it by  the following formula :

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