Calculate() return unusual result when trying to return TRUE()

[fc_wg]

Hi All,

I have been scratching my head trying to figure out what happen to my DAX. I simply just want to return a true or false from my calculated measure but it's given me a lot grieve.

Here is the calculated measure I am trying to write:

VAR booked_units =  CALCULATE(
                        SUM('Freight - Supplier Inbound'[Booked_Units]), 
                        FILTER('Freight - Supplier Inbound', NOT ISEMPTY('Freight - Supplier Inbound'))
                    )
VAR ordered_units = CALCULATE(
                        SUM('Purchase Order'[Ordered_Units]), 
                        FILTER('Freight - Supplier Inbound', NOT ISEMPTY('Freight - Supplier Inbound'))
                    )
RETURN IF(booked_units >= ordered_units, TRUE(), FALSE())

Before I use the above measure this is the result I am seeing which is correct:

But as soon as I tried to add the above measure this is what I get. It not only returned the wrong result and also made the "Ordered Units" blank (If I have 10+ fields in the table it'll run into memory issue error): 

This is my dataset model (I have to make the freight table one-to-many bi-directional as 1 purchase order can have more than one freight transactions):

Where am I doing something wrong here? Any help is much appreciated.

Thanks.

[lbendlin]

why bidirectional though? Try to use TREATAS instead.