Forum Discussion

sdgiss's avatar
sdgiss
Icon for Helper I rankHelper 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] ) )))
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
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] ) )))
sdgiss's avatar
sdgiss
Icon for Helper I rankHelper I
5 years ago

This is the one! Thank you so much wdx223_Daniel!!