Power BI adds a row when I put a calculated column in a table

[craigjlane]

Hello,

I am trying to create a table with multiple calculated columns.  However, when I add a new caluclated column, it adds a new row for the "Name" field.  An example is below:

As you can see, it adds a new column for Shaggy Rogers with each new calculated column.  Condition 1 and Condition 2 are as follows:

Condition 1 = IF(

    MDD[Test 10] = "True" && MDD[Out] = "True" && MDD[Less than -10] = "True", "YES!", "")

Condition 2 = IF(

    MDD[Test 7] = "True" && MDD[In] = "True" && MDD[Less than -10] = "True", "YES!", ""

    )

Both conditions are data type "text" but don't necessarily need to be.  I can change them to "True/False" or numeric values if it is necessary to make this table work.  

Any help is greatly appreciated.  Thank you!

[Uzi2019]

Hi @craigjlane 
It is showing you the result of not satisfying like blank "". 
can you provide the sample data or complte data so better for us to understand the data and requirement??