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] ) )))
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

sdgiss , Try like

Max Speed All Dates = CALCULATE ( MAX ( fData[Max Speed] ), FILTER ( ALL ( dDate ), dDate[Date] ) ,not(isblank(fData[Max Speed] )) )