Blank graph when incorporating date table

Hello QwertyMartijn 

I think you need to make sure that your measure considers the relationship between the "Herstelverzoeken" table and the date table. You can do this by using the appropriate column from the date table in your measure. Here's an updated version of your code that incorporates the date table:

CALCULATE(

    COUNT(Herstelverzoeken[Dossieritem]),

    FILTER(

        Herstelverzoeken,

        Herstelverzoeken[Dossieritemcode] = "63"

            && RELATED('DateTable'[Date]) = MAX('DateTable'[Date])

    )

)

Please note that you need to replace 'DateTable'[Date]’ with the actual column name from your date table.

Now I assume that there is a relationship between the "Herstelverzoeken" table and the date table based on a common column (e.g., a date column). If such a relationship doesn't exist, you may need to establish it using Power BI's relationship editor.

Try using this updated code, and hopefully, it resolves the issue with the table turning blank when you put a date table on the x-axis.

If this has solved your problem, kindly mark my post as solution.

Cheers