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
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
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.