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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors