Forum Discussion
Return a concatenated string value based on calculation
Greetings everyone!
I need help with the following moment:
There are 2 columns:
1) Say the first column is a name of product
2) Second column is a part that belongs to a certain product
A particular part can be assigned to any product:
What I want:
To create a measure, where:
- DAX checks IF:
- part belongs to only one project - it returns the name of the project (i.e. 1st column's value)
- part belongs to a couple of projects - it returns concatenated string where project names are concatenated via comma
The result will be in the third column. Thank you!
Anonymous
Please try= VAR CurrentProject = SELECTEDVALUE ( TableName[Name] ) VAR CurrentPartTable = CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[Part #] ) ) RETURN IF ( COUNTROWS ( CurrentPartTable ) = 1, CurrentProject, CONCATENATEX ( CurrentPartTable, TableName[Name], ", ", TableName[Name], ASC ) )
10 Replies
- tamerj1
Community Champion
Anonymous
Please try= VAR CurrentProject = SELECTEDVALUE ( TableName[Name] ) VAR CurrentPartTable = CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[Part #] ) ) RETURN IF ( COUNTROWS ( CurrentPartTable ) = 1, CurrentProject, CONCATENATEX ( CurrentPartTable, TableName[Name], ", ", TableName[Name], ASC ) )- tamerj1
Anonymous
Happy to hear that. Thank you for marking my reply as acceptable solution
- tamerj1
Anonymous
Didn't know they are repeated. Please use= VAR CurrentProject = SELECTEDVALUE ( TableName[Name] ) VAR CurrentPartTable = CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[Part #] ) ) VAR ProjectNames = DISTINCT ( SELECTCOLUMNS ( CurrentPartTable, "@Name", TableName[Name] ) ) RETURN IF ( COUNTROWS ( ProjectNames ) = 1, CurrentProject, CONCATENATEX ( ProjectNames, [@Name], ", ", [@Name], ASC ) )
- tamerj1
Hi Anonymous
Do you want to create a measure or a calculated column? Can you share the same sample data as copy/paste?