---
schema_version: "1"
id: 0252c0703f748199f131fb105abb039be766f23c0e1d5c617020c1d54dae3793
title: Convert a Measure Field Type to Dimension
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_data_prep_recipe_convert_measure_to_dimension.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_convert_measure_to_dimension.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 7b9aa5260bae3e9e66c51c81bcd767341777b2bee796801b7cf9c3319989c820
description: When you load data into a dataset, CRM Analytics tags a dimension field as a measure if it contains only numbers. For example, CRM Analytics tags a numerical Room Number field as a measure, even though it’s actually a dimension that identifies rooms. To use dimension functionality, such as grouping and filtering by dimension fields, use the To Dimension transformation to change the measure field type to dimension.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Convert a Measure Field Type to Dimension

When you load data into a dataset, CRM Analytics tags a dimension field as a measure if it contains only numbers. For example, CRM Analytics tags a numerical Room Number field as a measure, even though it’s actually a dimension that identifies rooms. To use dimension functionality, such as grouping and filtering by dimension fields, use the To Dimension transformation to change the measure field type to dimension.

### Required Editions

<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:center;vertical-align:top;" id="d32097e25">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d32097e25 ">To create a recipe:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d32097e25 ">Edit Analytics Dataflows OR Edit Dataset Recipes</td>
          </tr>
        </tbody>
      </table>

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note To convert a measure to a dimension in a Data Prep recipe, see [Number to Text Transformation: Convert the Column Type](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_measuretodimension.htm&release=264.0.0&type=5 "When you load data into a dataset, CRM Analytics tags a text (dimension) column as a number (measure) column if it contains only numbers. For example, CRM Analytics tags a numerical Room Number column as the number type, even though it’s text that identifies rooms. To group and filter by a number column, use the Number To Text transformation to change a Number column type to Text. You can group and filter by text columns only.").

1. On the column header of the measure field, click ![Column menu button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_replication_actions_button.png), and then select **To Dimension**.
    
    ![The column dropdown for a measure column shows lots of transformations, including the To Dimension transformation.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_recipe_toDimensionTransformationOption.png)
2. Click **Add** and save the recipe.

Run the recipe to create a new field with the dimension field type.