Forum Discussion
JustinDoh1
Post Prodigy
1 year agoSimple 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])...
- 1 year ago
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
pallavi_r
Super User
1 year agoHi 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
- JustinDoh11 year ago
Post Prodigy
pallavi_r So, it is not required, correct?
- pallavi_r1 year ago
Super User