Simple question on DAX

[JustinDoh1]

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.

[pallavi_r · Accepted solution]

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

[JustinDoh1]

@pallavi_r  So, it is not required, correct?

[pallavi_r]

Hi @JustinDoh1 , It is required.

Thanks,

• Pallavi