Use ALL and an additional filter criteria

[Anonymous]

Is it possible to write a DAX measure that lets me select ALL for a certain column, but then filter that column in the same measure? For example, I'd like to write a formula like this:

Measure = 
CALCULATE( 
SUM( Table[Column1]),
ALL(Table[Column2]),
Table[Column2] > 5 && Table[Column2] < 10
)
)

Where I use ALL to remove the filters on that specific column, but then apply my own filters directly on that column instead.

Thanks! 

[az38 · Accepted solution]

Hi @Anonymous 

try to use combination of FILTER() and ALL() like

Measure = 
CALCULATE( 
SUM( Table[Column1]),
FILTER(ALL(Table[Column2]),
Table[Column2] > 5 && Table[Column2] < 10)
)
)

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

Yep, this helped. I realize now that I was missing a filter in my statement and that's why I was getting a blank value. Thanks!