Forum Discussion

AhmadBakr's avatar
AhmadBakr
Icon for Helper IV rankHelper IV
2 years ago
Solved

Filter precedence in DAX functions

Greetings folks,   I was surprised that the two below definitions resulted in totally different results. The first (using FILTER and ALL) gave the correct result, while the second counted all the r...
Need Help
  • AhmadBakr's avatar
    AhmadBakr
    2 years ago

    Anonymous 

    For this case, the result is correct, and identical to the FILTER case. If we use the same logic, then also here COUNTAX will return a scalar value hence all conditions will be meaningless.

     

    I guess the dynamics of applying the filters is that filters coming from CALCULATE conditions are applied, then the table is evaluated and the expression is calculated. In my failing case, the condition coming from CALCULATE was overpowered by the ALL wrapped around the table name in the COUNTAX, hence cleared the condition filter.

     

    I hope my guessing is right!

AhmadBakr's avatar
AhmadBakr
Icon for Helper IV rankHelper IV
2 years ago

A worthy update: The below also worked:

OrdersRemTot =
CALCULATE(
    COUNTAX(
        Open_PO,
        Open_PO[PO_Ref]
    ),
    ALL(Open_PO),
    Open_PO[Matched Amount SAR] <> Open_PO[Amount SAR]
)
Which means it is always safer to keep any filteration of the tables in the condition part of CALCULATE and do not apply it inside the expression, I guess?
AhmadBakr's avatar
AhmadBakr
Icon for Helper IV rankHelper IV
2 years ago

Anonymous 

For this case, the result is correct, and identical to the FILTER case. If we use the same logic, then also here COUNTAX will return a scalar value hence all conditions will be meaningless.

 

I guess the dynamics of applying the filters is that filters coming from CALCULATE conditions are applied, then the table is evaluated and the expression is calculated. In my failing case, the condition coming from CALCULATE was overpowered by the ALL wrapped around the table name in the COUNTAX, hence cleared the condition filter.

 

I hope my guessing is right!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi AhmadBakr ,

    I think the conclusions of your follow up post below the thread are completely correct and we are basically all in agreement on the conclusions of our discussion, so I think there is absolutely no problem with what you are saying!

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.