Troubleshoot a Missing DAX Measure in Excel PivotTable Values
Question details
Determine why a CONCATENATEX DAX measure does not appear in the Values area of an Excel PivotTable.

- 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.
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.
Check the measure and PivotTable Data Model
Use these checks to distinguish a missing field from a measure that produces no visible result.
Select the PivotTable and open the PivotTable Fields pane. Expand the table where the measure was saved and look for the measure by name.
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.
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.
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.

Prepare a reproducible example for further diagnosis
Use an anonymized example when the formula and model checks do not explain the behavior.
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.

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.




