Forum Discussion

PowerBI-Curious's avatar
PowerBI-Curious
Icon for Helper I rankHelper I
9 years ago
Solved

Unsure what I need... Merging columns OR Visualisations

Hi =)   I am in need of a solution and I am not sure what the simplest way to do this. My problem is:    My data has multiple "Critical Risks" and each "Critical Risk" has multiple "Critical Cont...
Need Help
  • PowerBI-Curious's avatar
    PowerBI-Curious
    9 years ago

    They are not currently merged, but I need them merged. I did this really simply this morning with:

     

    Critical Risk/Control = 'CCVS Verification List Report'[Critical Risk] &"|"& 'CCVS Verification List Report'[Critical Control (Verification and Evidence)]

     

    Thanks  =)

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

From your description, what I am missing is why it is counting those two events together.

PowerBI-Curious's avatar
PowerBI-Curious
Icon for Helper I rankHelper I
9 years ago

They are not currently merged, but I need them merged. I did this really simply this morning with:

 

Critical Risk/Control = 'CCVS Verification List Report'[Critical Risk] &"|"& 'CCVS Verification List Report'[Critical Control (Verification and Evidence)]

 

Thanks  =)