Forum Discussion

stanislav_dugas's avatar
stanislav_dugas
Helper III
5 years ago
Solved

Impossible mapping

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 ...
  • v-easonf-msft's avatar
    5 years ago

    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.