IN & AND Operator

[mmh]

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 · Accepted solution]

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.

[tamerj1]

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 }
    )
)