topic IN & AND Operator in DAX Commands and Tips

IN & AND Operator

mmh — Tue, 20 Sep 2022 12:42:22 GMT

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!

Re: IN & AND Operator

tamerj1 — Tue, 20 Sep 2022 19:09:54 GMT

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

Re: IN & AND Operator

Anonymous — Wed, 21 Sep 2022 05:29:13 GMT

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.