Visual Chart from missing inputs in the table

[rodrigues_ear]

Hi,

I have a scenario that seems simple but has been challenging for me.

I manage multiple systems/servers that send log data to a SQL database to indicate they are ON. I import this data into Power BI to track their status over time—by date, month, etc.

To represent this setup, I created two tables:

1. A Date table containing all dates of the year.
2. A Logs table storing system/server logs.

These tables are linked by date.

I can analyze the data to show when the systems are ON by counting the "ON" status from the STATUS column. However, the issue is that no data is logged when a system is OFF (e.g., on Jan 2, 2025, System #2 is OFF, so no entry is recorded):

I'm not sure how to do it, but I need to identify when a system was OFF—essentially, when the count of "ON" entries is missing or differs from expectations. This is what I need:

How can I do that!?

[lbendlin]

To report on things that are not there you need to use disconnected tables and/or crossjoins

[rodrigues_ear]

Could you please share how to do that?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...