Forum Discussion

Saxon10's avatar
Saxon10
Post Prodigy
5 years ago

CONCATENATEX unique value

Hi   I have a two tables are Data and Report, both tables contain the same headers are “Item” and “Comments”.   DATA   In data table the item columns contains prefix only and the same item cont...
Need Help
MFelix's avatar
MFelix
Super User
5 years ago

Hi Saxon10 ,

 

I have created a table with the SUFIX and a column on the report also with the sufix then made the following setup:

 

Now add the following measure:

Comments Values = 
COALESCE (
    CALCULATE (
        CONCATENATEX ( VALUES ( DATA[Comments] ); DATA[Comments]; "|-|" );
        CROSSFILTER ( REPORT[SUFIX]; SUFIX[SUFIX]; BOTH )
    );
    "NA"
)

 

Result below and in attach PBIX file: