Merging Columns using distinct ID number

[Anonymous]

Hey

I have extracted the table below using the formular stated below, because I want to use the table as a visual;

Active Ticket Table = CALCULATETABLE(Tickets,Tickets[value.statecode@OData.Community.Display.V1.FormattedValue]="Active")

As seen in the table there are duplicate data in the Value.TicketNumber, ProjectName & StatusCode, which I could have used remove duplicate data to remove. However, the RequestType column has distinct request Types. 

Value.TicketNumber	ProjectName	RequestType	StatusCode	StateCode
2023-IDM-0000001	Phone Case	Builder's linen	Pending Assignment	Active
2023-IDM-0000002	Project Spinoff	W&D of ODRW	Awaiting Documents	Active
2023-IDM-0000003	DRW-0128YNS	Coperate Search	Merging	Active
2023-IDM-0000003	DRW-0128YNS	Easement Access	Merging	Active
2023-IDM-0000003	DRW-0128YNS	Builder's linen	Merging	Active
2023-IDM-0000004	YU-Jason Project	Easement Access	Pending Assignment	Active
2023-IDM-0000005	MP-927-2023	Encroachment	Awaiting Documents	Active
2023-IDM-0000006	719-YUGNT-2022	Builder's linen	Merging	Active
2023-IDM-0000007	2023-Builders Project	City-to-City General	Awaiting Documents	Active
2023-IDM-0000007	2023-Builders Project	Encroachment	Awaiting Documents	Active
2023-IDM-0000008	Aspen Woods Project 2021	Ground Tie	Merging	Active
2023-IDM-0000008	Aspen Woods Project 2021	City-to-City General	Merging	Active
2023-IDM-0000009	Alpine Grounding	Builder's linen	Pending Assignment	Active
2023-IDM-0000010	Brent Jdrainage	Encroachment	Pending Assignment	Active
2023-IDM-0000011	Ground Opening Project	W&D of ODRW	Pending Assignment	Active
2023-IDM-0000012	City-to-City Drone	W&D of ODRW	Merging	Active
2023-IDM-0000012	City-to-City Drone	Coperate Search	Merging	Active
2023-IDM-0000012	City-to-City Drone	Easement Access	Merging	Active

Whih formula can i use to make the Active intakes table appear as seen below please either in the visual or in the table

Value.TicketNumber	ProjectName	RequestType	StatusCode	StateCode
2023-IDM-0000001	Phone Case	Builder's linen	Pending Assignment	Active
2023-IDM-0000002	Project Spinoff	W&D of ODRW	Awaiting Documents	Active
2023-IDM-0000003	DRW-0128YNS	Coperate Search, Easement Access, Builder's linen	Merging	Active
2023-IDM-0000004	YU-Jason Project	Easement Access	Pending Assignment	Active
2023-IDM-0000005	MP-927-2023	Encroachment	Awaiting Documents	Active
2023-IDM-0000006	719-YUGNT-2022	Builder's linen	Merging	Active
2023-IDM-0000007	2023-Builders Project	City-to-City General, Encroachment	Awaiting Documents	Active
2023-IDM-0000008	Aspen Woods Project 2021	Ground Tie, City-to-City General	Merging	Active
2023-IDM-0000009	Alpine Grounding	Builder's linen	Pending Assignment	Active
2023-IDM-0000010	Brent Jdrainage	Encroachment	Pending Assignment	Active
2023-IDM-0000011	Ground Opening Project	W&D of ODRW	Pending Assignment	Active
2023-IDM-0000012	City-to-City Drone	W&D of ODRW, Coperate Search, Easement Access	Merging	Active

Thank you in advance for your help

[Anonymous · Accepted solution]

I used the response in this link and it worked

Solved: Re: Combining Rows based on the ID of that table - Power Platform Community (microsoft.com)

[parry2k]

@Anonymous your reply didn't help? How I will know what is not working? Are you getting the wrong result or blank or error? How I expect to provide the answer without knowing what is not working?  

[parry2k]

@Anonymous add a measure for Request Type and then use this measure in the table visual along with other columns:

Request Type = 
CONCATENATEX ( FILTER ( 'Table', 'Table'[StateCode] = "Active" ), [RequestType], ",")

[Anonymous]

Thanks but this did not work. I would expect that the formula would use the ticket number as a distinct identifier to concatenate the Request Types. Please can you provide another formula