Forum Discussion

mmh's avatar
mmh
Icon for Helper I rankHelper I
3 years ago
Solved

IN & AND Operator

Hi,

I have a measure with IN & AND operator, it has no error, but in visual it giving msg as: 

Calculation error in measure: function Contrainrow doesnot support comparing values of type of Integer with values type of text. Consider the value or format function to convert one of the values:

 

The measures is:

RExp_m = CALCULATE(
[TExp],
ContractExposure[Contract_Type] IN  {5896,3430,895,1398,200609}
 &&
ContractExposure[Status_Id] IN {566,2664,100246})
 
NB:Both Column are Integer
Any suggestion appreciated! 
Thank You!
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi mmh ,

    I have create a simple sample, please refer to it to see if it helps you.

    The [Contract_Type] and [Status_Id] are whole number type.

    Then the measure works well.

    RExp_m = 
CALCULATE (
    [TExp],
    ContractExposure[Contract_Type]
        IN { 5896, 3430, 895, 1398, 200609 }
        && ContractExposure[Status_Id] IN { 566, 2664, 100246 }
)

    If it still does not help, please provide some sample data without privacy informtion and desired output with more details.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi mmh 
    Please try it this way

    RExp_m =
CALCULATE (
    [TExp],
    FILTER (
        ContractExposure,
        ContractExposure[Contract_Type]
            IN { 5896, 3430, 895, 1398, 200609 }
            && ContractExposure[Status_Id] IN { 566, 2664, 100246 }
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi mmh ,

    I have create a simple sample, please refer to it to see if it helps you.

    The [Contract_Type] and [Status_Id] are whole number type.

    Then the measure works well.

    RExp_m = 
CALCULATE (
    [TExp],
    ContractExposure[Contract_Type]
        IN { 5896, 3430, 895, 1398, 200609 }
        && ContractExposure[Status_Id] IN { 566, 2664, 100246 }
)

    If it still does not help, please provide some sample data without privacy informtion and desired output with more details.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.