Measures

Copper Contributor

Hello,

 

I am trying to create a very simple measure in PowerPivot. I go through all the steps, but when I click "OK" no measure is created. Here is a screenshot of the create measure screen:

Measure Problem.JPG

Does anyone have any idea why this is happening? 

3 Replies

Hi Pamela,

 

How do you know it's not created? You don't see it if open the model (on ribbon Power Pivot->Manage)?

Thanks for your reply.

 

When I go to Measures-Manage Measures, it is just not there … that is how I know it has not been created, but I don't know why Excel isn't showing it as a measure after all the steps I have taken.

Pamela, looks strange. To clarify:

Here are Power Pivot group icons

image.png

First you click Add to Data Model for your table

Second created new measure as above

Third check Manage Measures and see nothing

 

Like this?