Forum Discussion

Pamela Nathe's avatar
Pamela Nathe
Copper Contributor
Oct 11, 2018

Measures

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:

Does anyone have any idea why this is happening? 

  • Hi Pamela,

     

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

    • Pamela Nathe's avatar
      Pamela Nathe
      Copper Contributor

      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.

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        Pamela, looks strange. To clarify:

        Here are Power Pivot group icons

        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? 

         

Resources