Need urgent help please!!!

[cuongtrinh2197]

Hi, can someone show me the way to bring the field Customer part number to the visual table?

My relationship looks fine but the error happened when I tried to bring the customer part number to the table, If the customer doesn't have a specific part number for the part they bought, the return will be our part number.

Please find my attachment for details:
https://shorturl.at/uI99n

[ryan_mayu]

i think you need to improve the data model. 

Now you can try to create a column

customer part number = maxx(FILTER(fCustProduct,fCustProduct[Part number]=fSales[Part number]),fCustProduct[Customer Part Number])

then add this column to the table visual

[cuongtrinh2197]

Many thanks Ryan,
Is there any chance for me to use your syntax acting as a measure?
My company just empowered me to do the measure and visual table without modifying the dataset such as add a new column,...

[ryan_mayu]

pls try this

Measure = maxx(FILTER(fCustProduct,fCustProduct[Part number]=max(fSales[Part number])),fCustProduct[Customer Part Number])

[cuongtrinh2197]

Sorry Ryan I just checked again, if you can see the measure return to the swrong result
For example, line 1, customer 1 sale order but the return value in the measure column is the part number of customer 2

[cuongtrinh2197]

Ryan, the measure return the wrong value

[ryan_mayu · Accepted solution]

@cuongtrinh2197 

pls see if this is what you want

Measure =

VAR _cpn=maxx(FILTER(fCustProduct,fCustProduct[Part number]=max(fSales[Part number])&& fCustProduct[Customer]=max(fSales[Customer])),fCustProduct[Customer Part Number])

return if (_cpn="",max(fSales[Part number]),_cpn)