True/False in a new field after comparing two fields.

[baBI123]

Hello, 
I am a begginer at POWER BI and a begginer/intermediate at excel. I need help!
I need to compare the MASTER.PART NUMBER field on the MARK ROTABLES table to the PART NUMBER field on the CAP LIST table. Then, I need to have POWER BI to write TRUE if there are matching part numbers in the SERIALIZED field in the MARK ROTABLES table and FALSE if there are not. 

If I have not explained myself clearly enough, please ask for calrification.
I am new to all of this and I will take any help I can get, I greatly appreciate it!

[Ashish_Mathur]

Hi,

Share your source data and also show the expected result.

[baBI123]

CAP LIST TABLEMARK ROTABLES TABLE (WITH SERIALIZED FIELD)

Hi Ashish,

my data source comes from excel spreadsheets (data was imported to excel from an oracle database)
I need the T/F result to show in the "serialized" field. 
Is this what you are asking for?? 

[Ashish_Mathur]

Hi,

Share the link from where i can download your file.

[baBI123]

what do you mean?

[Ashish_Mathur]

Upload the file to Google Drive and share the download link here.

[baBI123]

Unfortunately, I can not do that because there is private information on the file that cannot be shared..
However, can you explain a solution to me?

[v-shex-msft · Accepted solution]

Hi @baBI123,

You can add below calculate column to 'MARK ROTABLE' table to check if current row is exist in 'CAP LIST' table:

SERIALIZED ='MARK ROTABLE'[MASTER_PART NUMBER] IN ALL ( 'CAP LIST'[PART NUMBER] )

Regards,

Xiaoxin Sheng

[baBI123]

I did some research on calculated columns and this worked like a charm. Thank you @v-shex-msft

[baBI123]

Hello v-shex-msft,
I am getting this error reading. Please help!
Thank you

[v-shex-msft]

Hi @baBI123,

My formula is calculated column, you can't direct use it as measure. BTW, your formula has duplicate start part.('measure = SERIALIZED =')

In addition, if you want to use measure, you can try to use below measure formula:

Measure version:

Measure = MAX('MARK ROTABLE'[MASTER_PART NUMBER]) in ALLSELECTED( 'CAP LIST'[PART NUMBER] )

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

Explore these two functions - RELATED() and LOOKUPVALUE()