Forum Discussion

VenkatTav's avatar
VenkatTav
Frequent Visitor
3 years ago

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

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.
Need Help

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    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's avatar
      VenkatTav
      Frequent Visitor
      3 years ago

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