Expand Rows With Checkboxes
If you are happy with your general selection of rows but want to be able to add more combinations based on specific needs, you could work with an extra Planning and Reporting Visual with a check box to activate new combinations of dimensions in your visual.
In this case, you set up a visual that includes the same combination of keys that you want to be able to add rows for.
To create a checkbox in your Planning and Reporting Visual, you need a measure that reference an Aimplan MeasureKey to generate a boolean value. That could look something like this:
Add your measure as you would with any other measure to a column section in your Aimplan Planning and Reporting Visual and choose Data Type; Boolean and Aggregation Strategy; Unique.
Your visual should look something like this now:
Once you have set up your check box visual, you need to create a measure that generates rows for this combination of dimensions in your original Planning & Reporting Visual. Use the same type of logic that you do for limiting rows with your Current User Key measure, but in this case to expand rows instead. What you need to consider is; under which conditions do you want the measure to generate a value?
To maintain the logic of your row limitations and expansions, we will use the Current User Key to create a measure that controls the rows, as this is the measure you currently use for limiting them.
In this case, our first limitation is that we want to generate a value on rows with existing values on Plan Sales Quantity and/or on Sales Quantity. We then want to add a value on rows that do not have existing values on either of these measures, but to have a value on the ActiveProduct measure, generated by your checkbox.
Your measure could look like this:
In a normal Power BI table, that combination would generate this:
As displayed in the table, CurrentUserKeySales measure generates values where Plan Sales Quantity and/or on Sales Quantity has existing values, Active Product generates values for the rows that have a checkbox in your Add products for customers without Actuals-table, and your CurrentUserKeySalesAddProduct-measure generates a value on all rows.
If you would set CurrentUserKeySalesAddProduct as your Aimplan User Key in your Planning & Reporting visual, your added rows will appear as displayed on the top of this page.