Need a Power bi Dax function to giving missing data in related table

[srinayana]

Hi All,
I HAVE 2 tables.
Table 1: CMDB
Table 2: CPUutilization report

Table 1 is static report with list of unique Server name
Table 2 consist of data for entire month with date, Server name and it's Avg utilisation % for each day.

The issue is Table 2 will have some Servers missing on daily basis.

My requirement is to get the list of Servers from CMDB missing in Table 2 for particular date Selected.

Kindly do the needful.

 

[Matt Allington]

Write this measure
Count of missing servers =countrows(filter(cmdb,calculate(countrows(table2))=0))

pit the server names on rows in a matrix/pivot and the measure in values.