Incorrect results when using more than one scalar expressions in ISAFTER()

[lichun198201977]

Hi, 

This is the raw table "Attempt1Table" I manually input:

                                                    

ISAFTER() worked well when using only one expression:

                                                    

                                                    

However, the incorrect data appeared when using the two scalar expressions together:

                                                   

Is it a known issue? How to solve it?

[johnt75 · Accepted solution]

From https://dax.guide/isafter/, the second column, in your example State, is only compared when the first column , Country, has the same value as the comparison.

If you want different behaviour you will need to create a different filter condition that uses logic which matches your use case.

[lichun198201977]

Thanks a lot, I found the related comment in the code.

BTW, is there any plan to add it to the corresponding Microsoft documentation? I believe that there should be a significant number of readers confused by it.

[johnt75]

I agree, it should be made clearer in the official documentation although their example does hint at the behaviour.