You can only move it to a different location in the Calculation Area of the table in which it was created. “To move a measure, you can cut and paste the formula in the Calculation Area. A TechNet article provided just the guidance I needed: I looked through all of the buttons on the ribbon in the Power Pivot window and saw nothing helpful so I turned to Google (yes, I still choose Google over Bing). I thought there must be a better way to move a measure. The table in which it is located is more of an organization issue rather than a technical calculation issue. It should be noted that in the current version of Power Pivot, you can put calculated measures on any table in the model without affecting the result of a query using the measure. The idea of copying, pasting, and renaming several dozen measures was less than appealing. Due to the lack of the ability to filter data in Power Map, I had to create several calculated measures in my data model to limit the data shown in my map. Going this route means pasting your measure, renaming the old measure, and then renaming the new copy of the measure to the original name. You can copy the formula from the formula bar and paste it into a cell on another table, but you will get a warning that you can’t have two measures with the same name. You can’t just copy a calculated measure to a new table by cutting and pasting. Rebuild or move any calculated measures to the new table.
0 Comments
Leave a Reply. |