Filter column

[Anonymous]

Hello  -  I received a boolean error message on this calculated column formula.   Any help is appreciated!

I am trying to put a "Yes"  or a "No"  in a column.    If the value of the "shipped price"  =  0   then it should say "0 Value Order".  

If there is any value above zero...it should say "Rev Order".     

Zero Value = CALCULATE(IF(SUMX('Flu_Shipped Orders','Flu_Shipped Orders'[Shipped Price]=0),"$0 Value Order", "Rev Order"))

[ibarrau · Accepted solution]

Hi, it looks like you have SUMX syntax with an error. Let's see. I'm not sure if you want a new measure or calculated column so I will send both codes:

Calculated Column:

Zero Value = IF('Flu_Shipped Orders'[Shipped Price]=0,"$0 Value Order", "Rev Order")

Measure: (consider that SUMX(<table>, <expression>) this means the filtering would be in the table and the expresion would be a column or math between them)

Zero Value = 
    IF(
        SUMX(
            FILTER('Flu_Shipped Orders','Flu_Shipped Orders'[Shipped Price]=0)
            , 'Flu_Shipped Orders'[COLUMN TO SUM]
        )
        ,"$0 Value Order"
        , "Rev Order"
    )

Be carefull with the measure that needs to be completed. I wrote "Column to sum" where you have to complete.

Hope this helps,

Regards,