Forum Discussion
Simple question on DAX
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.
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
3 Replies
- pallavi_rSuper User
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- JustinDoh1Post Prodigy
pallavi_r So, it is not required, correct?
- pallavi_rSuper User