Unsure what I need... Merging columns OR Visualisations

[PowerBI-Curious]

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 Controls" (seperate columns) some of the "Critical Controls" are the same text for "Critical Risks" however different. e.g below

Critical Risk - Vehicle Collision and Critical Control - Positive communication

Critical Risk - Vehicle impact and Critical Control - Positive communication

At the moment it would count the above as 2 positive communications when really it should be 1 for vehicle collision Pos Com and 1 for vehicle impact pos com.

I need to measure the top failing controls on a graph. So I am thinking my options are combine the two columns so I have a new column that says "Vehicle Impact - Positive Communication" and "Vehicle Collision - Positive Communication"

OR

There may be a way to make my current data set work in the visulisations without manipulating the data.

Interested in thoughts on both actions and some info on how to execute either.

https://1drv.ms/x/s!ArM9L8ohYGT4gQhszs0ssIc8haUT

Thank you,

PowerBI-Curious 

[Greg_Deckler]

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

[PowerBI-Curious · Accepted solution]

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  😃