i am new to powerbi. trying to get new column with yes or no based on other columns

[sanjay009]

for 3 tables with columns  student id,subject, passorfail , i created a report with columns from 3 reports. each table has a column (passorfail) with data 'Yes' and 'No 'i want to add new calculated column with data ;yes' or 'no' based on 3 table columns (passorfail). if any yes the ew column should disply yes, if all no it diaply ;No;

table 1:

studentid subject passor fail

1              math    yes

2              math       No

3             math       yes

table 2:

studentid subject passor fail

1              science    yes

2              science       No

3             science      yes

table 3:

studentid subject passor fail

1              english    yes

2              english       No

3             english       yes

expected report:

studentid  passorfail_table1  passorfail_table2 passorfail_table3  new column

1                 yes                          yes                       No                        yes

2                   No                         No                         No                      No

3                     No                       No                          yes                       yes

Thank you for the help.

[v-lionel-msft · Accepted solution]

Hi @sanjay009 ,

Your example data seems a bit wrong:

First, create relationship between tables:

Then, creaet a measure:

Measure 3 = 
IF(
    MAX(table1[passor fail]) = "yes" || MAX(table2[passor fail]) = "yes" || MAX(table3[passor fail]) = "yes",
    "yes",
    IF(
        MAX(table1[passor fail]) = "no" && MAX(table2[passor fail]) = "no" && MAX(table3[passor fail]) = "no",
        "no"
    )
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.