Forum Discussion

sdgiss's avatar
sdgiss
Helper I
5 years ago
Solved

Maintaining filter context after applying ALL function

First off, let me state that I am very new to DAX. The question I have relates to maintaining filter context after applying the ALL function to create a new measure. The new measure identifies the...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    sdgiss  just adding a if function in your measure

    Max Speed All Dates = IF([Daily Max],CALCULATE ( MAX ( fData[Max Speed] ), FILTER ( ALL ( dDate ), dDate[Date] ) )))
CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, amitchandak , Anonymous , wdx223_Daniel , a quick question please: can you guys shed some light on this expression?

FILTER ( ALL ( dDate ), dDate[Date] )

what's the differece between it and ALL ( dDate )? Thanks in advance!

sdgiss's avatar
sdgiss
Helper I
5 years ago

CNENFRNL there is no need for the use of FILTER in this formula, as ALL is more than enough to achieve the result. My immature DAX brain was overcompensating with FILTER when writing this measure.