topic Unable to display created measures in the excel pivot table in DAX Commands and Tips

Unable to display created measures in the excel pivot table

gordon_tsui — Mon, 16 Sep 2024 06:06:15 GMT

Hi. I would like to raise a question about creating new measures at the excel pivot table.

When I create new measures at pivot table, it should automatically appear in the pivot table item list. But it is strange I can't find my new measures created the value field list. I am sure my DAX formulas for the pivot table measure is correct. Because I basically simply copied my colleague's raw data for the pivot table. His excel file has created a few calcualtion measures for the pivot table and I simply copy the DAX formula, so the DAX formula must be free from errors. But strangely, the measures appear in the pivot table item list of my colleague's excel file, but not in my file. I tried to search on internet for solutions, but not very helpful.

Could someone help me identify what happened? Thank you very much!

Re: Unable to display created measures in the excel pivot table

bhanu_gautam — Mon, 16 Sep 2024 09:54:24 GMT

gordon_tsui , There might be some issue with column or table reference, can you share some examples

Re: Unable to display created measures in the excel pivot table

gordon_tsui — Thu, 19 Sep 2024 09:49:00 GMT

Greetings. For confidential reason maybe I am not able to share the file directly. But I have checked the table reference. The table reference in my self-made pivot table is the same as my colleagues does. So it should be free from error.

I also try to copy the whole referenced table into another new excel book, try to make a new pivot table, create the new measure, and redo again. But the new measures still do not display in the value field of the pivot table.

Anyway, if you have any suggestion on how I can share information with you or you need any further clarification, feel free to let me know! Thank you.

Re: Unable to display created measures in the excel pivot table

dharmendars007 — Sat, 21 Sep 2024 11:36:33 GMT

Hello gordon_tsui ,

Please refer this link on how to make most of the support group it also has information on how to share the data..

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/m-p/1626726#M32906

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

Re: Unable to display created measures in the excel pivot table

gerardoro73 — Thu, 12 Jun 2025 23:17:43 GMT

Same issue here, did you find a solution?