Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Use ALL and an additional filter criteria

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! 

1 ACCEPTED SOLUTION
az38
Community Champion
Community Champion

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


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

View solution in original post

2 REPLIES 2
az38
Community Champion
Community Champion

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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

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!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.