Forum Discussion

EnrichedUser's avatar
EnrichedUser
Helper III
5 years ago
Solved

Measure: Find Partial Text in Unrelated Table

Hi,   I have two unreleated tables with 1 common field. My goal is to create a measure that can identify, for any given SalesOrderID, if there exists a partial match for "Order added to warehous...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    EnrichedUser , Try some thing like 

     

    if(isblank(countx(filter(ApplicationAudit,SalesOrder[SalesOrderID] = ApplicationAudit[TransactionNumber] && search("Order added to warehouse", ApplicationAudit[Message],,0) >0),ApplicationAudit[Message])), "No", "Yes")

EnrichedUser's avatar
EnrichedUser
Helper III
5 years ago

Hi amitchandak 

Thank you for your quick reply. Unfortuntaly, this was not able to resolve.

looking at your dax:
if(isblank(countx(filter(ApplicationAudit,search(SalesOrder[SalesOrderID], ApplicationAudit[Message],,0) >0),ApplicationAudit[Message])), "No", "Yes")

it does not take into account the message field for "Order added to warehouse"

 

Also, SalesOrderID would not be in Message but TranscationNumber

amitchandak's avatar
amitchandak
Super User
5 years ago

EnrichedUser , Try some thing like 

 

if(isblank(countx(filter(ApplicationAudit,SalesOrder[SalesOrderID] = ApplicationAudit[TransactionNumber] && search("Order added to warehouse", ApplicationAudit[Message],,0) >0),ApplicationAudit[Message])), "No", "Yes")