Power BI table - split one particular row and transform into two rows

[bilingual]

Hi, i have an excel data table with multiple values:

One of these rows contains data which has a faulty definition i cant change the rawdata.

1. The values from this row should be split and transformed into two new rows in the same table. 
2. The values should be split acording to the weight of two variables in the same table.

Is is possible in Power bi or by SQL code before dataload?

Example of existing data:

Type	Subgroup	Value
Test 1	Mix	100
Test 1	A	200
Test 2	B	200

Which should be transformed into:

Type	Subgroup	Value
Test 1	Mix	50
Test 2	Mix	50
Test 1	A	200
Test 2	B	200

[lbendlin]

There is not enough information in your sample data? How do you decide which row to split, and where is the ratio mentioned?

[bilingual]

This is just an example, but it is Test 1 with Subgroup Mix which needs to be split in to the 2 Mix subgroups.

The ratio is the percentage between Test 1 and Test 2, in the example, it is 50/50

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.