Find Missing Value

Hi Syndicate_Admin ,

Thanks for the reply from lbendlin / Ashish_Mathur .

You want to use Power BI Desktop to identify missing values for specific codes in a table, right?

Let me provide you with a possible solution with a sample table.

Here's the table where we're going to calculate the missing values:

This is our reference table for the EX in your description:

Create a measure:

measure = 
CALCULATE(
    COUNTROWS('EX'),
    EXCEPT(
        VALUES('EX'[Value]),
        VALUES('Table'[Value])
    )
)

Using a table visualization object, drag the fields of the EX table in and view them against the “Table” table on the left, which is where the missing values are displayed:

If the problem is not resolved, please provide a Power BI Desktop file in progress (with sensitive information removed) that fully covers your issue or question in a usable format (not a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive (set up public access), SharePoint, or a Github repository, and then share the URL of the file.

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!