+ Reply to Thread
Results 1 to 4 of 4

New DAX Measure Not Appearing in PT Field List

  1. #1
    Registered User
    Join Date
    06-29-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    43

    New DAX Measure Not Appearing in PT Field List

    Hi,

    I just created a new measure in PowerPivot (Excel 2010) and after refreshing my pivot table, the measure still does not appear in the field list. Any ideas on what could be causing this?

    Thanks!

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: New DAX Measure Not Appearing in PT Field List

    Attach a sample workbook to see if it will disappear on another version
    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    06-29-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    43

    Re: New DAX Measure Not Appearing in PT Field List

    I couldn't come up with a good way to sanitize the data. However, I think I figured it out. Not sure if this is an issue with just Excel 2010, but in order for measures to show up, the pivot table has to be created by going under the PowerPivot ribbon and selecting it there (as opposed to the Insert ribbon or the "Summarize with PivotTable" option under the Design ribbon for the data table). Doing it this way apparently links the pivot table to the data model instead of the data table because anytime I update the data table, I have to go into the data model to refresh that first before the changes are reflected as part of a refresh in the pivot table.

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: New DAX Measure Not Appearing in PT Field List

    Every PT or PPT should be refreshed if source data was changed.
    You can tick this option:

    ptrefresh.jpg

    to be sure your PPT will be updated.
    but in the meantime, without closing and reopening file you can refresh PPT manually or use VBA Change_event (or something like that) to refresh PPT automatically everytime when you will change source table.
    You don't need refresh DataModel then PPT, enough PPT

    --
    btw. create PPT with data model from dummy data is very simple.
    and saw measure immediately in PPT
    I did it without any problem with privacy.
    Attached Files Attached Files
    Last edited by sandy666; 09-26-2017 at 06:07 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Pivot Measure so I can put a text field in If condition is not true
    By rv02 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-06-2016, 08:59 AM
  2. Replies: 1
    Last Post: 12-17-2015, 02:57 PM
  3. [SOLVED] Argument List of UDF not Appearing in Cell
    By jdmcheme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 11:46 AM
  4. [SOLVED] Add-in Menu List not appearing in add-in tab
    By abdulgafoor2007 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-17-2012, 09:22 AM
  5. Replies: 2
    Last Post: 08-01-2012, 01:24 PM
  6. Replies: 3
    Last Post: 12-09-2011, 06:32 AM
  7. Replies: 0
    Last Post: 11-02-2005, 06:17 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1