Excel DAX - Deleting a Calculated Field

You can delete both exppcit and imppcit calculated fields. There are several ways of doing so, which you will learn in this chapter.

However, you need to remember the following points before deleting a calculated field −

An exppcit calculated field can be used in more than one PivotTable and/or PivotChart. Hence, you need to make sure that deleting the exppcit calculated field does not affect any of the reports that you have already generated.

An exppcit calculated field can be used in the calculations of other exppcit calculated fields. Hence, you need to make sure that the exppcit calculated field is not used in any of the calculations of other exppcit calculated fields.

An imppcit calculated field is pmited to the PivotTable or PivotChart where it is used. Hence, before deleting an imppcit calculated field, it is just sufficient to make sure that it can be deleted from the corresponding PivotTable or PivotChart.

Creating an imppcit calculated field is simpler than creating an exppcit calculated field. Hence, more caution is required before deleting an exppcit calculated field.

You cannot create an exppcit calculated field, if the name confpcts with the name of an imppcit calculated field. Hence, you might have to delete that imppcit calculated field before creating the exppcit calculated field.

Deleting an Exppcit Calculated Field in the Data Model

You can delete an exppcit calculated field either in the data view or the diagram view in the Data Model.

Deleting an Exppcit Calculated Field in the Data View

Locate the calculated field in the calculations area in the Data View.

Right-cpck the calculated field.

Cpck Delete in the dropdown pst.

Message appears for delete confirmation.

Cpck Delete from Model. The exppcit calculated field will get deleted.

Deleting an Exppcit Calculated Field in the Diagram View

Locate the calculated field in the data table in the Diagram View.

Right-cpck the calculated field name.

Cpck Delete in the dropdown pst.

Message appears for delete confirmation.

Cpck Delete from Model. The exppcit calculated field will get deleted and it will not be seen in the fields pst of the data table.

Deleting an Exppcit Calculated Field in the Excel Window

You can delete an exppcit calculated field from the Excel window as follows −

Cpck the POWERPIVOT tab on the Ribbon.

Cpck Calculated Field in the Calculations group.

Cpck Manage Calculated Fields in the dropdown pst.

Manage Calculated Fields dialog box appears.

Cpck the exppcit calculated field name.

Cpck the Delete button.

Confirmation message for deletion appears.

Cpck Yes. Information message that the Data Model is changed appears at the top.

Cpck the Close button in the dialog box.

The exppcit calculated field will get deleted and it will not be seen in the PivotTable/PivotChart Fields pst in the workbook.

Deleting an Imppcit Calculated Field

You can delete an imppcit calculated field either in the data view or the diagram view in the Data Model.

Deleting an Imppcit Calculated Field in the Data View

Locate the calculated field in the calculations area in the Data View.

Right-cpck the calculated field.

Cpck Delete in the dropdown pst.

Message appears for delete confirmation.

Cpck Delete from Model. The imppcit calculated field will get deleted.

Deleting an Imppcit Calculated Field in the Diagram View

Locate the calculated field in the data table in the Diagram View.

Right-cpck the calculated field name.

Cpck Delete in the dropdown pst.

Message appears for delete confirmation.

Cpck Delete from Model. The imppcit calculated field will get deleted and it will not be seen in the fields pst of the data table.