Fill missing month row with zero

Hi Ralf123,

First of all, I would model your data in your Events table differently, like this: 

I used a "Date" column because you have more than one instance of the same event per month.

Then, I would create a Calendar table, rather than an All Months table, e.g.:

Calendar =
ADDCOLUMNS (
    CALENDAR ( "01-Jan-2010", "31-Dec-2020" ),
    "Year", YEAR ( [Date] ),
    "Month", FORMAT ( [Date], "MM" ),
    "Month Name", FORMAT ( [Date], "MMM" )
)

Then create a relationship between the two tables using the [Date] column.

Then you should be able to create a Matrix visual that resembles your Result Table.

Let me know how you get on.