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
BenBlackswan
Helper V
Helper V

How to get rid a column in a Calculated table so that I can turn that table into a Measure group?

hello all,

 

I have one column in this calculated table as shown below

 

Nietzsche_2-1742174914103.png

 

 

 

I want to delete it so that I can turn this table into Measure Group. But there I can not find the delete option, I can only hide it?

Do you know why this is a case?

Nietzsche_0-1742175166358.png

 

Thank you. 

1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hi @BenBlackswan 

 

You cannot delete a column that is created with a calculated table.  Adding a calculated table without specifying a column name or not adding any columns creates a single row value column. You can instead use Enter data, add a measure to the resulting table or re-home some and then delete the column. This would turn the table into a measure table.

danextian_0-1742179031593.pngdanextian_1-1742179069739.png

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

1 REPLY 1
danextian
Super User
Super User

Hi @BenBlackswan 

 

You cannot delete a column that is created with a calculated table.  Adding a calculated table without specifying a column name or not adding any columns creates a single row value column. You can instead use Enter data, add a measure to the resulting table or re-home some and then delete the column. This would turn the table into a measure table.

danextian_0-1742179031593.pngdanextian_1-1742179069739.png

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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
Top Kudoed Authors