Forum Discussion
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. ...
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"
)
)
I tried the above solution before posting , but still tried once more and below is the error.