Need help with comparinmg 2 columns

[Anonymous]

Hi there,

I have two table A and B.
Now i would like to sum up the Spend for all parts in Table B with a particular colour provided the parts are present in Table A.

Table A
Supplier, Part

Table B
Supplier,Part,Colour,Spend .

The two tables are related on the Supplier though but not Part.

Have not mentioned the other columns here..

[Syndicate_Admin]

Don'@bespeck,

I need more details. Could pls provide an example, or share your pbix files. Remember to delete sensitive information.

Best regards

Lucien

[v-luwang-msft]

Hi @Anonymous ,

Need more details.Could pls provide a sample ,or share your pbix files.Remember to remove the confidential information.

Best Regards

Lucien

[Anonymous]

@v-luwang-msft 

Thanks for responding.Yes it is a one to many model and i somehow managed it.I used the in operator to see if the part in B is in A.

[selimovd]

Hey @Anonymous ,

how is the relationship between the two tables?

Is it a one to one relationship or one to many? Please post a screenshot of the data model, then I can help you with the measure.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Anonymous]

@selimovd

Thanks for responding.Yes it is a one to many model and i somehow managed it.I used the in operator to see if the part in B is in A.

[selimovd]

If it's a one to many relationship you shouldn't have a problem.

Then one supplier has also has only one part. Then you can just pull all the columns in a table and get the result.

Or where are you struggling?

Otherwise please provide the tables, picture of the relationship and the desired result.

We want to help you, but you have to give the information...

[amitchandak]

@Anonymous , Create a concatenated key

key = [Supplier] & " " & [Part]

If that can create 1-M join between two table

then you can filter part using A and color using B

[Anonymous]

@amitchandak Thanks for the reply but i didnt want to use the combination  of supplier and Part to join the two tables as they already have a relation with the Supplier.

I wanted to create a measure for the sum of the spend based on the colour and part that match with A.