"Add Measure" Isn't Coming Up (even after I select "Add Data to Data Model")

spiyarali

New Member
Joined
Aug 30, 2019
Messages
1
I am trying to have texts in a value field in a pivot table, and my understanding is that creating a Measure (concatenating the text) is the best way to do so. However, I am unable to create a measure when I am in the Pivot Table, as even after I select "Add Data to Data Model" when creating the pivot table, I only see "Remove from Active Tab" when right-clicking the table in PivotTable Fields on the right-hand side after creating the table. "Add Measure" doesn't seem to be an option at all. Anybody know how to fix this? I also tried creating a measure after exporting the table to PowerPivot but can't seem to be able to do so there either. Would be grateful for any help and assistance
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
I am trying to have texts in a value field in a pivot table, and my understanding is that creating a Measure (concatenating the text) is the best way to do so. However, I am unable to create a measure when I am in the Pivot Table, as even after I select "Add Data to Data Model" when creating the pivot table, I only see "Remove from Active Tab" when right-clicking the table in PivotTable Fields on the right-hand side after creating the table. "Add Measure" doesn't seem to be an option at all. Anybody know how to fix this? I also tried creating a measure after exporting the table to PowerPivot but can't seem to be able to do so there either. Would be grateful for any help and assistance
I am trying to have texts in a value field in a pivot table, and my understanding is that creating a Measure (concatenating the text) is the best way to do so. However, I am unable to create a measure when I am in the Pivot Table, as even after I select "Add Data to Data Model" when creating the pivot table, I only see "Remove from Active Tab" when right-clicking the table in PivotTable Fields on the right-hand side after creating the table. "Add Measure" doesn't seem to be an option at all. Anybody know how to fix this? I also tried creating a measure after exporting the table to PowerPivot but can't seem to be able to do so there either. Would be grateful for any help and assistance
Please I'm having the same issue. What do I do
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top