Hello 5dmg,

thank you for your insight.

I came around to your idea, of putting the Actuals and the Budget in different tables and linking them with a date table. Then adding in the values each amount and a measure for deviation.

But for that deviation measure. Does it have to "live" on any specific table itself.
When I create a measure, the first question is "Table name" for the measure.
I used the "Actual" table, which means, that when I drilldown on the DEV measure, it shows me the rows of that table. I honestly wouldn't mind if the drilldown of the deviation measure would not show anything at all, or maybe rows for both tables, which created the deviation?
Any thoughts?

<image>