In matrix 0 instead of empty cell

Hey Erburi92 ,

the problem you are facing is based on the auto-exist behavior, read a detailed explanation here: Understanding DAX Auto-Exist - SQLBI

To overcome this problem you have to create a star schema creating dimension tables for the site and the month, then create relationships between the dimension tables and your FraudSite table (the fact table). Here you will find an introduction to data modeling with Power BI: Design a data model in Power BI  - Learn | Microsoft Docs

You have to be aware that you also need to fill the blank values for the site in the FraudSite, e.g., not applicable. The value also has to be present in the dimension table.

Hopefully, this helps to tackle your challenge.

Regards,
Tom