Forum Discussion

mstone's avatar
mstone
Icon for Helper I rankHelper I
4 years ago
Solved

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...
Need Help
  • hnguy71's avatar
    hnguy71
    4 years ago

    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

hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
4 years ago

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

mstone's avatar
mstone
Icon for Helper I rankHelper I
4 years ago

Confirmed that the second formula is working perfectly.  Thank you so much!!