Forum Discussion
Impossible mapping
- 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.
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.