Forum Discussion

JustinDoh1's avatar
JustinDoh1
Post Prodigy
1 year ago
Solved

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

  • 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