Forum Discussion

mstone's avatar
mstone
Helper 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

mstone's avatar
mstone
Helper I
4 years ago

Just tried that and received the following error message:  

They are in the same visual.  Perhaps I have made a sytax error.  I may not see your reply until tomorrow morning.  I do appreciate your help and patience!  

hnguy71's avatar
hnguy71
Super 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
    Helper I
    4 years ago

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

  • mstone's avatar
    mstone
    Helper I
    4 years ago

    I tried both.  The first seemed to produce duplicate entries but the second appeared to work perfectly.  Due to a save issue with the file I had to set up the simple table again and it seems to be functioning differently than before.  Just troubleshooting the difference but I think the second formula may have been the solution.  🙂  If I can verify that, I will definitely click "Accept as a Solution".  Thank you for your help!