How to Display Duplicate/Repetitive Multiple Rows in a Single Cell of a Table/Matrix in POWER BI 

REQUIREMENT: Compress multiple row values in a single cell value of a table or matrix using CONCATENATEX function in Power Bi as shown in the Fig.1  

  Fig.1 

SOLUTION: 

Step1: Import table using Getdata in Power BI Desktop as shown in Fig.2 

 Fig.2 

Step2: Add relationships between the tables as shown in Fig.3. There are two types of relationship: One-to-One relationship and One-to-Many/Many-to-One relationship used here.

Fig.3 

Step3: Write a MEASURE to check one Agreement ID with corresponding AppValue and AppScope values as shown below: 

APPNAME =  

IF(HASONEVALUE(dyn_agreement[dyn_name]),    

CONCATENATEX (‘Application.AppName’, 

‘Application.AppName’[Application_AppName], 

UNICHAR (13) & UNICHAR (10), 

‘Application.AppName’[Application_AppName]) 

) 

APPSCOPE =  

IF(HASONEVALUE(dyn_agreement[dyn_name]),    

CONCATENATEX (‘Application.Scope’, 

‘Application.Scope’[Application_ScopeName], 

UNICHAR (13) & UNICHAR (10), 

‘Application.AppName’[Application_ScopeName]) 

) 

 Step4: Add APPNAME and APPSCOPE to the table as shown in Fig.4 .  

Fig.4 The Output 

Hope this helps!