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...
  • 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.

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.