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] ) )))
Anonymous's avatar
Anonymous
Not applicable
5 years ago

sdgiss   Hey Mate ,

You can try this .

 

Max Speed All Dates = if(HASONEVALUE(dDate[Date]),
                                     CALCULATE ( MAX ( fData[Max Speed] ), FILTER ( ALL ( dDate ), dDate[Date] ) ),Blank() )

 


Max Speed per Racer =if(HASONEVALUE(dRacerDetail[Racer]), CALCULATE(MAX(fDataReference[Max Speed] ),Blank() )

Try this and let me know
You can use this as well.