Forum Discussion

qwaszx55's avatar
qwaszx55
Frequent Visitor
8 years ago
Solved

Filter using OR from 2 different tables.

I'm sure this is much easier than I'm experiencing but its crushing me at the moment.   I have a service contracts table with say "CompanyName,ContractNo,Status" and a servicecontractsitem table th...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    qwaszx55,

    In DirectQuery mode, create calculated columns using BILASolution's DAX in Report View, you can also get expected result.


    Regards,
    Lydia

BILASolution's avatar
BILASolution
Solution Specialist
8 years ago

Hi qwaszx55

 

Try this...

 

First, create 2 calculated columns

 

Status = RELATED('Service Contract'[Status]) 
Status or Reason = IF(OR('Service Contract Item'[EndReason] = "";'Service Contract Item'[Status] = "Terminated");"Yes";"No")

 

 

Second, use "Status or Reason" calculated column to filter.

 

 

 

I hope this helps

 

Regards

BILASolution