Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

creating new table based on two table condition

There are two tables A and B and I want to merge below tables into the new one with subjects when IEYN and NSYN =yes. 

The below dax which i created combining both yes and no subjects

EligibleSubjects =
UNION(
SELECTCOLUMNS(
FILTER('Subject Eligibility', 'Subject Eligibility'[IEYN] = "Yes"),
"Subject", 'Subject Eligibility'[Subject]
),
SELECTCOLUMNS(
FILTER('Treatment Period Inclusion Criteria', 'Treatment Period Inclusion Criteria'[NS_DSELIGYN] = "Yes"),
"Subject", 'Treatment Period Inclusion Criteria'[Subject]
)
)

 

Table A 
SubjectIEYN
Subject 1Yes
Subject 2Yes
Subject 3Yes
Subject 4Yes
Subject 5No
  
Table B
Subject NSYN
Subject 1Yes
Subject 2Yes
Subject 3Yes
Subject 4No
Subject 5Yes
Show and Tell
Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , what if the issue ?

     

    You can try like 

     

    filter(Union(TableA, TableB), [IEYN] ="Yes")

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks Amit. There are other columns in the tables so i want just the subjects of the both tables in the new table with condition [IEYN] ="Yes" (Table A) and NSYN = "Yes" (Table B)