topic Re: Simple question on DAX in DAX Commands and Tips

Simple question on DAX

JustinDoh1 — Mon, 18 Aug 2025 23:14:21 GMT

I have following DAX that I have been using but I was wondering about this for a long time.

DAX =
IF( HASONEVALUE( tblTest[Name]),

var CurrentTestValue = SELECTEDVALUE( tblTest[Field])

return
CALCULATE(
SELECTEDVALUE( tblMain[Rating]),
TOPN(1,
FILTER(
ALL( tblMain ),
CurrentTestValue <= tblMain[CutOff]
),
tblMain[MaxTotal],
ASC
),
All(tblMain)
)
)

My question is:

1) What is point of All(tblMain)? I know that it would not make a difference if that part is there or not.

Re: Simple question on DAX

pallavi_r — Tue, 19 Aug 2025 06:53:44 GMT

Hi JustinDoh1

Yes it is very much required to ignore all the external filters. It makes sure the comparison is on the entire set of data in the table ignoring the filters if any report, page, slicers or selection.

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,
Pallavi

Re: Simple question on DAX

JustinDoh1 — Tue, 19 Aug 2025 17:34:50 GMT

pallavi_r So, it is not required, correct?

Re: Simple question on DAX

pallavi_r — Tue, 19 Aug 2025 17:47:29 GMT

Hi JustinDoh1 , It is required.

Thanks,

Pallavi