Forum Discussion

cuongtrinh2197's avatar
cuongtrinh2197
Frequent Visitor
2 years ago
Solved

Need urgent help please!!!

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 th...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    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)
     
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

pls try this

Measure = maxx(FILTER(fCustProduct,fCustProduct[Part number]=max(fSales[Part number])),fCustProduct[Customer Part Number])
 
 
cuongtrinh2197's avatar
cuongtrinh2197
Frequent Visitor
2 years ago

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