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

[spiyarali]

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

 

[Vickie Toria]

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