How to concatenate several conditions to sum values

[abdoumanni]

Hello community,

 i'm trying to solve a problem about how to concatenate several conditions, here is an exemple :

Data i have :

	Data
Division	Amount	comments
Business partner	200	A
Costumer service	100	B (half amount is made also with A)
Call center	150	C (50 is made also with A)
Web	80	D
Total	530

Resultat i want :

	Amount
Business partner	300	(50 made with Costumer service and 50 made with call center)
Costumer servuce	100
Call center	150
Web	80
Total	630

Thanks in advance

[jameszhang0805]

@abdoumanni  If changing your comments from "B (half amount is made also with A) " to "B (50 is made also with A)
I can generate the result as your request. 

Your data source is too messy, I strongly suggest you let IT help clean the data before you start building the model and writing the measure.  I used PQ to split and clean your data source, and then write the DAX code to get the results, I don't recommend you analyze the data in this way, this is just like an exercise.
How to concatenate several conditions to sum value.pbix