Cannot make cube measure working - error due to null values

Hi ivana_tomekova 

This error happens because the allocation is trying to write to a cell where your *reference measure is BLANK/NULL*.

Cube allocation only works where the reference measure has an existing value - it cannot allocate to blank cells.

Here’s how to fix it:

1. Wrap your Reference Measure with COALESCE to return 0 instead of BLANK*
Reference Measure = COALESCE([Your Actual Measure], 0)

Or

Reference Measure = IF(ISBLANK([Your Actual Measure]), 0, [Your Actual Measure])
Then use this new measure as the "Reference Measure" in your Cube Allocation.

2. Check for missing dimension combinations:

Make sure for every intersection you are allocating to, the reference measure actually has data. Even 1 missing combo will throw this error.

3. Filter before allocating

In the Cube Planning editor, apply a filter: `Reference Measure is not blank` so you only allocate to cells that have a base value.

From your screenshot it looks like some rows have `-` which is BLANK. Converting those to 0 should resolve it.

Let me know if this works

Thanks 😊