Forum Discussion
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...
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
Super User
Super Userpls try this
Measure = maxx(FILTER(fCustProduct,fCustProduct[Part number]=max(fSales[Part number])),fCustProduct[Customer Part Number])
Ryan, the measure return the wrong value
- ryan_mayu
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)