Not able to user OR function while filter two different tables in calculated measure

[VenkatTav]

Hi All,

I have requirement to get MAX(Table1.DATE) where Table1.status_type ="90,243,205" OR TABLE2.STATUS_TYPE="DH1", i'm creating this as a calculated measure.

 below is the error im getting. 

ERROR :

Code:

MISS_ITEM_RCV(205)_1_test =

CALCULATE(MAX(FORECLOSURE_STATUS[STATUS_DATE]),OR(FILTER(FORECLOSURE_STATUS,FORECLOSURE_STATUS[STATUS_TYPE] IN {"90","243","205"}),FILTER(SERVICE_CODE,SERVICE_CODE[SERVICE_CODE]="DH1"))

)

Thanks in advance.

[FreemanZ]

hi @VenkatTav 

try like:

MISS_ITEM_RCV(205)_1_test =

CALCULATE(

    MAX(FORECLOSURE_STATUS[STATUS_DATE]),

    OR(

        FORECLOSURE_STATUS[STATUS_TYPE] IN {"90","243","205"}, 

        SERVICE_CODE[SERVICE_CODE]="DH1"

    )

)

[VenkatTav]

I tried the above solution before posting , but still tried once more and below is the error.