Find Missing Value

[Syndicate_Admin]

Good morning community, I hope you are well
I need help with the following

I have to do something like that
A code has to have certain values associated with it
Ex:

Code	Value
COD1	ES-01
COD1	ES-02
COD1	ES-03
COD1	ES-04

That would be the standard value, all my codes should have the same values, from ES-01 to ES-04
How can I do something that in my table indicates that a value is missing
EXAMPLE: COD3 code is missing the value ES-03

I remain attentive to any questions.

Beforehand
Thanks a lot

[Syndicate_Admin]

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.

[Anonymous]

Hi @Syndicate_Admin ,

It looks like you have found a solution. Could you please mark this helpful post as “Answered”?

This will help others in the community to easily find a solution if they are experiencing the same problem as you.

Thank you for your cooperation!

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!

[v-aatheeque]

Hi @Syndicate_Admin ,

Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @Syndicate_Admin ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[v-aatheeque]

Hi @Syndicate_Admin ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[Anonymous]

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:

Code	Value
COD1	ES-01
COD1	ES-02
COD1	ES-03
COD1	ES-04
COD2	ES-01
COD2	ES-02
COD2	ES-04
COD3	ES-01
COD3	ES-02

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

Code	Value
COD1	ES-01
COD1	ES-02
COD1	ES-03
COD1	ES-04
COD2	ES-01
COD2	ES-02
COD2	ES-03
COD2	ES-04
COD3	ES-01
COD3	ES-02
COD3	ES-03
COD3	ES-04

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!

[Ashish_Mathur]

Hi,

PBi file attached.

Hope this helps.

[lbendlin]

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