Forum Discussion

ghaines's avatar
ghaines
Resolver I
4 years ago

CALCULATE filters as filter function vs boolean expression

I just fixed an issue and I don't understand how.   The brief was a unit count above and below our theoretical "minimum price" for a new order.   I used a simple boolean in a CALCULATE function: ...
v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi ghaines ,

 

A Boolean expression used as a filter parameter in a CALCULATE function corresponds to an equivalent FILTER expression that operates on all the values of a column.

 

This means that Equation 

CALCULATE([_UnitSalesFin],
        Transactions[Net Amount] < PlatinumPrice )

is actually equivalent to Equation

CALCULATE([_UnitSalesFin],
        FILTER( ALL(Transactions[Net Amount]), Transactions[Net Amount] < PlatinumPrice ) )

 

For more information, please refer to: How CALCULATE works in DAX 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ghaines's avatar
ghaines
Resolver I
4 years ago

Hi v-kkf-msft ,

 

As mentioned in the question, I am getting different results between the filter method and the boolean expression.  That's why I am making the post.  When I use the boolean expression, my data is not filtered.