Impossible mapping

[stanislav_dugas]

Hey Guys,

I am a bit strugling with figuring out if my issues is even solvable. Let me try to explain it.

I have a dataset where I have IDs that have a certain mapping to them splitting then on 3 groups Core/Solution/Transaction.

I also have a column giving me a contribution for solution. What does it mean is that if ID has value 20 and contribution 10% then 2 is part of solution and remaining is part of core. Only solution can have this kind of contribution. The Contribution values are only whole numbers like 10%,25%,50%,100%.

What i am trying to do is to create a value calculation that would give me the values after applying the contribution for solution and put the remaining delta under the core so in reality it would somehow split the ID into 2 portion one would be core and one Solution without actually creating new row in my dataset as part of a meassure.

ID	Value	Contribution %	Mapping	Value after aplying contribution	Delta to be added to Core	Expected Result
1	10	0	Core	10	0	28
2	20	10	Solution	2	18	2
3	30	0	Transaction	30	0	30

Is this even possible?

Thanks for any help.

Stan

[v-easonf-msft · Accepted solution]

Hi , @stanislav_dugas 

PowerBI doesn't support to  add additional rows by using measure.

You need to create a new calculated table as below:

Table 2 =
VAR tab =
    ADDCOLUMNS (
        FILTER (
        SUMMARIZE ( 'Table', 'Table'[ID], 'Table'[Delta To be added to Core] ),
        'Table'[Delta To be added to Core] <> 0
    ),
        "Value", "",
        "Solution Contribution %", "0",
        "Mapping", "Core",
        "Value After Appling contribution %", ""
    )
RETURN
    UNION (
        SUMMARIZE (
            'Table',
            'Table'[ID],
            'Table'[Delta To be added to Core],
            'Table'[Value],
            'Table'[Solution Contribution %],
            'Table'[Mapping],
            'Table'[Value After Applying contribution %]
        ),
        tab
    )

You can  also take a try the  function "append queries as new" in advanced editor.

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @stanislav_dugas 

Can you explin how you arrvied at the values Expected result in the image posted ?

What does ID refer to. Does each ID have 3 different possible values , Core/ Solution / Transaction.

If you can share the pbix it will help to understand better.

Cheers

CheenuSing

[stanislav_dugas]

Hi CheenuSing,

Each ID has only 1 value either its Core or Solution or Transaction.

Expected value is combination of Value after aplying contribution column and the Delta column where the delta needs to be allocated towards the Core part of the business.

So 1st ID= Value after contribution + Delta from Solution

2nd ID = Value after Contribution

3rd ID = Value after Contribution

Hope this helps.

Cant share the Pbix file since the data are confidential.

[v-easonf-msft]

Hi， @stanislav_dugas 
The table currently contains three rows of  sample data.

If possible ,can you share more sample data to help us understand the problem?

Best Regards,
Community Support Team _ Eason

[stanislav_dugas]

The green section is what i currently have in my data/Model.

Purple section is what i would like my meassure to create in the background without adding additional rows into my dataset.

The value for new rows equals to the delta column.