Forum Discussion
Filter column
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"))
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,
1 Reply
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,