Forum Discussion
mrothschild
Continued Contributor
5 years agoMatrix - data in data table not displayed when sliced
I have a pretty simple text-based matrix that has Asset Manufacturers, Model Types, and Serial Numbers as the Column hierarchy and Calendar Year, Month, Date as the Row hierarchy, and a simple measur...
- 5 years ago
I think using the Column of Event Description rather than a Measure is what I wanted.
DataZoe
Microsoft Employee
5 years agomrothschild I was looking at the documenation SELECTEDVALUE function - DAX | Microsoft Docs and because those have the same description that may be why it's not showing. Maybe try SELECTEDVALUE(distinct([text description column])), or include a column that will force each single row to show in the matrix.
mrothschild
Continued Contributor
5 years agoI think using the Column of Event Description rather than a Measure is what I wanted.
- DataZoe5 years ago
Microsoft Employee
mrothschild wonderful, glad you got it figured out!