Forum Discussion
Using CONCATENATEX to combine multiple rows by project ID
I have a list of projects and for each project there can be more than one risk. My goal is to combine the risks by project rather than combine all of the risks into a single entry. Is there a basic approach I can take to the DAX formula? Can I do this with a measure called "Combined Risks". My goal is to have one row per project in the final report.
Mike
Hey mstone ,
Can you try to copy and paste one of the following expressions?
Combined column = CALCULATE(CONCATENATEX(DIM_PROJECT_RISK, [RiskTitle], UNICHAR(10)), ALLEXCEPT(DIM_PROJECT_RISK, DIM_PROJECT_RISK[ProjectId]))AsMeasure = CALCULATE(CONCATENATEX(VALUES(DIM_PROJECT_RISK[RiskTitle]), [RiskTitle], UNICHAR(10)), ALLEXCEPT(DIM_PROJECT_RISK, DIM_PROJECT_RISK[ProjectId]))Here is a link you can download to a sample: https://1drv.ms/u/s!An8CCFsOzw0uhQYExSCu5Hj9NDon?e=7B3enE
12 Replies
Sorry for the delay. Here is an example of what it looks like now and how I would like it to look:
ProjectID
Risks
PRJ6319
Risk 1
PRJ6320
Risk 1
PRJ6320
Risk 2
PRJ6320
Risk 3
PRJ6321
Risk1
PRJ6321
Risk 2
ProjectID
Risks
PRJ6319
Risk 1
PRJ6320
Risk 1
Risk 2
Risk 3
PRJ6321
Risk 1
Risk 2
The tables didn't paste as desired but the idea is to combine the risks in a single cell so the result is a single project number entry. Thank you!
