Forum Discussion

AliBiktash99's avatar
AliBiktash99
New Member
3 years ago
Solved

Error Message Measure in PBI ( Urgent Please )

Revenue =
Var CODFees = IF(
AND(deliveries[sender._id] = "UiMNuYTbVmn",deliveries[cod.amount]>0),deliveries[pricing.priceBeforeVat]+7
,deliveries[pricing.priceBeforeVat]
)
RETURN
IF(
deliveries[sender._id] = "UiMNuYTbVmn",
CODFees,
deliveries[pricing.priceBeforeVat] - deliveries[pricing.expediteFee.amount]
)


Give me error :
DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

Can anyone support urgently

  • Hi AliBiktash99 
    The "cod. amount" / other variable is a text...
    Please check the data types and change them to numbers :

     

     

1 Reply

  • Hi AliBiktash99 
    The "cod. amount" / other variable is a text...
    Please check the data types and change them to numbers :