Forum Discussion
Helper VCombining values into one cell in a table
Hello All,
I have a report that has a couple of tables that are joined by a unique Key field (Feature ID). in a One to Many relationship. The fact table is a list of features each with an unique Feature ID. One of the dimension tables is a table (Labels) that lists the various platforms the feature is compatible with i.e., platform 5.01, platform 5.1, GDK 3.1, NGP etc... and the associated Feature ID.
What i've been asked to do is provide a matrix table with the values being all of the "labels" that apply to the Feature ID from the Features table. What I'm unsure of how to do is how to combine these values in the Labels table into one cell (assuming the values would be comma separated) so that BI sees them as one string and I can use them in a matrix table.
Any insight is greatly appreciated.
I would create this as a measure using CONCATENATEX.
Something like this should work if the Feature and Fact tables are related in your model:
ListLabels = CONCATENATEX( Labels, Labels[Label Name], ", ")
2 Replies
- Cmcmahan
Resident Rockstar
I would create this as a measure using CONCATENATEX.
Something like this should work if the Feature and Fact tables are related in your model:
ListLabels = CONCATENATEX( Labels, Labels[Label Name], ", ")
