---
schema_version: "1"
id: d5767aa7e3d17b5bb81d4ab64628cc1fa60c67488bc4d01eb6a344455992d2da
title: Override a Calculated Field or Metric in an Extended Model
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/c360_a_sl_override_metrics_calc_fields.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.c360_a_sl_override_metrics_calc_fields.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d4bb707d810e46945201842b41e45ba44ef5a333dc47cbc2e601d31d854801f7
description: Learn how to override a calculated field or metric in an extended model to preserve custom logic across base model updates. When you override a calculated field's formula or properties, or a metric's definition, that field or metric disconnects from the base model and stops receiving automatic updates.
products:
  - Data 360
release: "264"
---
# Override a Calculated Field or Metric in an Extended Model

Learn how to override a calculated field or metric in an extended model to preserve custom logic across base model updates. When you override a calculated field's formula or properties, or a metric's definition, that field or metric disconnects from the base model and stops receiving automatic updates.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: All editions supported by <span>Data 360</span>. See <a href="https://help.salesforce.com/s/articleView?id=data.c360_a_dc_editions.htm&amp;language=en_US" target="_blank"><span>Data 360</span> edition availability</a>.</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
      <colgroup>
        <col style="width:50%">
        <col style="width:50%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:left;vertical-align:top;" id="d1871e59">User Permissions Needed</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d1871e59 ">To override a calculated field or metric in an extended model:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d1871e59 ">
            <p>Permission set: </p>
            <ul>
              <li>Data Cloud Architect</li>

            </ul>
            <p>AND</p>
            <p style="margin-bottom:0;">Semantic Models object</p>
          </td>

        </tr>
      </tbody>
    </table>

## Before You Begin

Make sure that you have created an [extended model](https://help.salesforce.com/s/articleView?id=data.c360_a_sl_data_models_create_existing.htm&language=en_US&type=5).

## Override a Calculated Field

Override a calculated field to customize its formula or properties in your extended model.

Overriding a calculated field or metric lets you apply custom logic in your extended model while keeping the base model intact. After an override, the field or metric stops receiving updates from the base model until you revert it.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-semantics-264-0-0-production-enus/f7c99ab1-3439-4722-b925-34cb47455d89/images/icon_note.png)

Note Overriding a display name, description, or visibility disconnects only that property. Overriding any other calculated field property disconnects the entire calculated field. Overriding any metric property disconnects the entire metric.

1. In the Semantic Model builder, open the extended model.
2. Locate the calculated field that you want to override.
3. Click **Edit Calculated Field**.
4. Select the property (or multiple properties) that you want to change, and enter new values.
    
    - When you update the display name, description, or visibility, only that property is overridden. All other properties stay connected to the base model and continue to receive updates. For more information, see [Override a Field, Data Object, or Calculated Field Property](https://help.salesforce.com/s/articleView?id=analytics.c360_sl_override_a_field_data_object_or_calculated_field_property.htm&type=5&language=en_US).
    - When you update the formula expression, data type, aggregation, sentiment, data role, decimal places, treat Null as Zero, or filters, the entire calculated field disconnects from the base model and is considered overridden.
    - Other properties are not available for editing.
5. Save your changes.
6. When prompted, confirm the override.

An icon indicates that the calculated field is overridden. After the override, the calculated field no longer receives updates from the base model. Users who query the calculated field in the extended model see the overridden results.

To reconnect an overridden calculated field to its base model and restore the source definition, click **Revert**.

## Override a Metric

Override a metric to customize its definition and expose it as a unique metric in your org.

1. In the Semantic Model builder, open the extended model.
2. Locate the metric that you want to override.
3. Click **Edit Metric**.
4. Select the property (or multiple properties) that you want to change, and enter new values.
    
    - When you update the metric display name, description, filter, time dimension, additional dimensions, or insights, the entire metric disconnects from the base model and is considered overridden.
    - Other properties aren’t available for editing.
5. Save your changes.
6. When prompted, confirm the override.

An icon indicates that the metric is overridden. After the override, the metric no longer receives updates from the base model. Users who query the metric in the extended model see the overridden results.

To reconnect an overridden metric to its base model and restore the source definition, click **Revert**.

## Update a Dependent Metric After a Calculated Field Override

When you change a calculated field that one or more metrics depend on, a window opens and highlights the dependent metrics. Each dependent metric updates automatically based on the calculated field override, but doesn't appear to users on the browse page in Tableau Next.

To expose a dependent metric to users as a standalone metric in Tableau Next, give the metric a unique name or description, and then click **Publish**. The metric is overridden with the new name or description and appears on the browse page.

## Limitations

- You can't change a calculated measure to a calculated dimension, or a calculated dimension to a calculated measure, as an override.
- Not all calculated field or metric properties are available for editing. Review the list of allowed properties in the relevant sections.

#### See Also

- [Revert Overrides](https://help.salesforce.com/s/articleView?id=analytics.c360_a_sl_revert_overrides.htm&release=264.0.0&type=5 "Learn how to reconnect semantic definitions to an associated base model. This action reverts the semantic definition back to the current value of the base model. It doesn't delete the extended model.")