topic Re: Maintaining filter context after applying ALL function in DAX Commands and Tips

Maintaining filter context after applying ALL function

sdgiss — Mon, 26 Oct 2020 02:47:32 GMT

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 all-time (ALL dDates) best max speed for each bike racer. When reporting daily max speed on a specific date, there are records for those who did not record a value on that date (but did over the previous year). I realize this is probably a simple solution but I am struggling to have both the date filter context in the pivot table and the all-time best measure for only those racers that recorded a max speed on that specific date. I would only like to report an all-time best max speed for those that had a max speed record on a specific date. My pivot table is below with a specific example where Racer 9 & 10 have no data for 10/21 but still show up because they have an all-time max speed. The DAX formulae are as follows:

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

Max Speed per Racer =CALCULATE(MAX(fDataReference[Max Speed]),ALLEXCEPT(dRacerDetail,dRacerDetail[Racer]))

Thank you!

Steve

Re: Maintaining filter context after applying ALL function

amitchandak — Mon, 26 Oct 2020 04:11:36 GMT

sdgiss , Try like

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

Re: Maintaining filter context after applying ALL function

Anonymous — Mon, 26 Oct 2020 04:22:26 GMT

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.

Re: Maintaining filter context after applying ALL function

wdx223_Daniel — Mon, 26 Oct 2020 05:20:35 GMT

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] ) )))

Re: Maintaining filter context after applying ALL function

CNENFRNL — Mon, 26 Oct 2020 09:32:03 GMT

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!

Re: Maintaining filter context after applying ALL function

sdgiss — Mon, 26 Oct 2020 16:39:53 GMT

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

Re: Maintaining filter context after applying ALL function

sdgiss — Wed, 28 Oct 2020 10:16:59 GMT

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.