how to sum all the values without distinct filter ?

[AnandRanga]

This is my expression:

CALCULATE (
    SUM ( WHourOAI[WCalWorkingHour] ),
    FILTER (
        WHourOAI,
        FORMAT ( WHourOAI[TRANSDATE], "dd MMMM, yyyy" )
            > FORMAT ( "13 July, 2015", "dd MMMM, yyyy" )
            && FORMAT ( WHourOAI[TRANSDATE], "dd MMMM, yyyy" )
                < FORMAT ( TODAY (), "dd MMMM, yyyy" )
    )
)

It's working but not shosing the correct values, If I apply a month filter and check for the sum of feb month it shows only 8 i.e. unique or distinct value. but i want to sum  all the values because in my table it contains only 1 record on a single date. How to remove this default filter??

Thanks for your time.

[Greg_Deckler]

Not entirely sure, but it sounds like you want an ALL clause like:

CALCULATE (
    SUM ( WHourOAI[WCalWorkingHour] ),
    ALL(WHourOAI),
    FILTER (
        WHourOAI,
        FORMAT ( WHourOAI[TRANSDATE], "dd MMMM, yyyy" )
            > FORMAT ( "13 July, 2015", "dd MMMM, yyyy" )
            && FORMAT ( WHourOAI[TRANSDATE], "dd MMMM, yyyy" )
                < FORMAT ( TODAY (), "dd MMMM, yyyy" )
    )
)

Tough to say without sample data and expected output.