Forum Discussion
Filter column
- 6 years ago
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,
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,