accoPLANNING

See attached screenshots. I will provide example pbix by mail. Lock is set to ANY/OR and Lock_Category_Components and Always_lock seem to lock subtotals when used individually but not together. Non writable style is not applied and it’s possible to enter a value and have it visually propagated to lowest level cells – however, nothing is saved to database so lock on lowest level cell is working. Also, writable style is always applied to labels at a higher level of hierarchy.

When a shadow calculation is applied on a writeable measure, input on the measure cannot be given. It simply reverts to the output of the shadow calc. Measures should ALWAYS have precedens, so user inputs have top priority.

The shadow calculation on a specific row (and column) is being activated no matter which column you choose to input something in. So If my shadow calc is placed on col 3 and is a calculation based on col 1 + col 2 is being activated even though i'm typing in col 6 or another column.