Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
craigjlane
Frequent Visitor

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

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:
 
craigjlane_0-1699565437801.png

 

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!

 

 

1 REPLY 1
Uzi2019
Super User
Super User

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??

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors