Concatenate multiple columns into single column based on filters

[H_insight]

Hi All,

I am trying to concatenate 3 columns into 1 based on some filters with DAX measure but not getting much success.

Criteria:

• When a filter is selected i.e. “Program A”
  • Filter data on Type = "Project"
    • Concatenate the following columns:
      • “Id 2”, Update “Summary” and “Updated Type”
        • Ignoring any blank “Updated Type”.
      • 

Expected outcome:

Sample file.

Many thanks

[Anonymous]

Hi

Please find a solution in new column

Colonne =

var testblank= ISBLANK(Data[Updated Type])

var result=if(testblank = FALSE,COMBINEVALUES(",",Data[id 2],Data[Updated Summary],Data[Updated Type]))

return

result

[H_insight]

Thanks @Anonymous for looking into my query. Despite the calculated column showing the concatenated columns, it was not dynamic enough to deliver my table view. Thanks again.

[Greg_Deckler · Accepted solution]

@H_insight Maybe:

Summary Measure = 
  VAR __Table = FILTER('Table',[Updated Type] <> BLANK())
RETURN
  CONCATENATEX(__Table, [Id 2] & ", " & [Update Summary] & ", " &  [Updated Type], UNICHAR(10))

Put this in a Card visual.

[H_insight]

Thanks @Greg_Deckler fro your help. I have used your measure with a minor tweak to fit my needs in a table: