Pivot Table Issues

Troubleshoot a Missing DAX Measure in Excel PivotTable Values

Jason MillerJason Miller Nov 14, 2026 869 views

Question details

Determine why a CONCATENATEX DAX measure does not appear in the Values area of an Excel PivotTable.

Troubleshoot a Missing DAX Measure in Excel PivotTable Values
Product
Microsoft Excel Power Pivot and Data Model
Device & OS
not provided
Scenario
The user wants to show concatenated text from a DAX measure in a PivotTable alongside numeric measures.
Observed behavior
Numeric measures work, but the CONCATENATEX measure does not appear in the PivotTable Values area.
Before you start

Confirm that the PivotTable uses the Data Model containing the measure, and note whether the measure is missing from the field list or appears there but cannot be displayed in Values. Collect an anonymized example of the formula, source tables, and expected result.

Solution 1Recommended

Check the measure and PivotTable Data Model

Use these checks to distinguish a missing field from a measure that produces no visible result.

1
Find the measure

Select the PivotTable and open the PivotTable Fields pane. Expand the table where the measure was saved and look for the measure by name.

2
Verify the formula

In Excel, open Power Pivot > Measures > Manage Measures, if available, and inspect the CONCATENATEX measure. Confirm that its table and column references match the intended Data Model.

3
Refresh and test

Select the PivotTable, choose PivotTable Analyze > Refresh, and try dragging the measure from the field list to Values. Test it with a simple row field that should have matching source data.

4
Check relationships and filters

Open Power Pivot > Manage and use Diagram View to inspect relationships between the table being concatenated and the tables used in the PivotTable. Review the PivotTable's filters and row fields for a context that could leave no matching values.

Check the measure and PivotTable Data Model
The cause is not yet established: The available details do not identify a confirmed fix. Whether the measure is absent from the field list, unavailable in Values, or present but blank affects the next diagnostic step.
Free Microsoft Office alternative

Work with PivotTable Spreadsheets in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface for working with compatible Excel files. It can help you continue everyday spreadsheet work, but it does not fix Excel's Power Pivot or DAX measure behavior.

Use familiar spreadsheet tools to review and summarize dataOpen and edit compatible Microsoft Excel XLSX files for easier migrationWork with PivotTables for common data summariesGet a free, lightweight Office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why can I see numeric measures but not my CONCATENATEX measure?

The available information is not enough to establish the cause. Check the table containing the measure in PivotTable Fields, inspect the formula in Power Pivot > Measures > Manage Measures, and confirm whether the issue is a missing field or a blank result.

How do I check relationships used by the measure?

Open Power Pivot > Manage, then select Diagram View. Inspect the columns connecting the table used by CONCATENATEX to the tables supplying the PivotTable row fields and filters.

What should I share if my workbook contains confidential data?

Create a small workbook with fictional values that preserves the relevant table structure and relationships. Include the measure formula, PivotTable fields, business requirement, and expected result.

Will WPS Office fix an Excel DAX measure?

No. WPS Office is an alternative for compatible spreadsheet work, but it does not repair Excel's Data Model or Power Pivot measure behavior. Diagnose the DAX measure in Excel.