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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

We can merge two tables into one and then filter the dataset.

qwaszx55's avatar
qwaszx55
Frequent Visitor
8 years ago

How do you go about this in direct query mode? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    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