Find Missing Value

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

Hi,

PBi file attached.

Hope this helps.

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!

How about everyone, Very good day
Thank you very much for the answers

I found the next thing that worked for me and it's what I was looking for
Make a calculated column.

RESULT =

VAR RequiredCodes = {"ES-01","ES-02", "ES-03","XX","YY"} -- Codes to search

VAR IdentifierCodes =

CALCULATETABLE(

VALUES(Table1[ChargeCode]), -- Valores ChargeCode

ALLEXCEPT(Table1,Table1[Identifier]) -- Removes filters, except for identifiers

)

VAR CodesMissing =

EXCEPT(RequiredCodes, Identifier Codes) -- Compares the required codes with those in the identifier

RETURN

IF(

COUNTROWS(MissingCodes) > 0,

"Missing: " & CONCATENATEX(MissingCodes, [Value], "), "), -- Concatenated Missing Codes

"All Codes"

)

The code compares the required load codes with the codes present for each identifier. If codes are missing, it returns a message listing which ones are missing; if they are not missing, it returns a message indicating that all codes are present.