topic Pull in value based on multiple criteria from one table to another in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pull-in-value-based-on-multiple-criteria-from-one-table-to/m-p/3282505#M157268 <P>Hello! I have two tables as following:<BR /><STRONG>Payments</STRONG></P><TABLE border="1"><TBODY><TR><TD>Refer_no</TD><TD>CPT Code</TD><TD>Payment</TD></TR><TR><TD>230192</TD><TD>U002</TD><TD>1.00</TD></TR><TR><TD>230192</TD><TD>89X</TD><TD>2.00</TD></TR><TR><TD>220183</TD><TD>50C</TD><TD>2.50</TD></TR></TBODY></TABLE><P><BR /><STRONG>Charges<BR /></STRONG></P><TABLE border="1"><TBODY><TR><TD>Refer_no</TD><TD>CPT Code</TD></TR><TR><TD>230192</TD><TD>U002</TD></TR><TR><TD>230192</TD><TD>89X</TD></TR><TR><TD>220183</TD><TD>50C</TD></TR><TR><TD>220183</TD><TD>9Z1</TD></TR><TR><TD>240522</TD><TD>9Z1</TD></TR></TBODY></TABLE><P><BR />I want to create a calculated column on the charges table which pulls in the "payment" column from the Payments table <STRONG>FOR the matching&nbsp;</STRONG>Refer_no and CPT Code. There is a blank if there is no existing value in the payments table. So result would look as follows:<BR /><BR /></P><P><STRONG>Charges<BR /></STRONG></P><TABLE border="1"><TBODY><TR><TD>Refer_no</TD><TD>CPT Code</TD><TD>Payment</TD></TR><TR><TD>230192</TD><TD>U002</TD><TD>1.00</TD></TR><TR><TD>230192</TD><TD>89X</TD><TD>2.00</TD></TR><TR><TD>220183</TD><TD>50C</TD><TD>2.50</TD></TR><TR><TD>220183</TD><TD>9Z1</TD><TD><STRONG>BLANK</STRONG></TD></TR><TR><TD>240522</TD><TD>9Z1</TD><TD><STRONG>BLANK</STRONG></TD></TR></TBODY></TABLE><P><BR />I've tried FILTER and Lookupvalue, but it ends up filtering the resulting visual so that only the matches show and the blanks are removed. Please help! Thank you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P> Tue, 13 Jun 2023 23:32:38 GMT mish2212 2023-06-13T23:32:38Z Pull in value based on multiple criteria from one table to another https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pull-in-value-based-on-multiple-criteria-from-one-table-to/m-p/3282505#M157268 <P>Hello! I have two tables as following:<BR /><STRONG>Payments</STRONG></P><TABLE border="1"><TBODY><TR><TD>Refer_no</TD><TD>CPT Code</TD><TD>Payment</TD></TR><TR><TD>230192</TD><TD>U002</TD><TD>1.00</TD></TR><TR><TD>230192</TD><TD>89X</TD><TD>2.00</TD></TR><TR><TD>220183</TD><TD>50C</TD><TD>2.50</TD></TR></TBODY></TABLE><P><BR /><STRONG>Charges<BR /></STRONG></P><TABLE border="1"><TBODY><TR><TD>Refer_no</TD><TD>CPT Code</TD></TR><TR><TD>230192</TD><TD>U002</TD></TR><TR><TD>230192</TD><TD>89X</TD></TR><TR><TD>220183</TD><TD>50C</TD></TR><TR><TD>220183</TD><TD>9Z1</TD></TR><TR><TD>240522</TD><TD>9Z1</TD></TR></TBODY></TABLE><P><BR />I want to create a calculated column on the charges table which pulls in the "payment" column from the Payments table <STRONG>FOR the matching&nbsp;</STRONG>Refer_no and CPT Code. There is a blank if there is no existing value in the payments table. So result would look as follows:<BR /><BR /></P><P><STRONG>Charges<BR /></STRONG></P><TABLE border="1"><TBODY><TR><TD>Refer_no</TD><TD>CPT Code</TD><TD>Payment</TD></TR><TR><TD>230192</TD><TD>U002</TD><TD>1.00</TD></TR><TR><TD>230192</TD><TD>89X</TD><TD>2.00</TD></TR><TR><TD>220183</TD><TD>50C</TD><TD>2.50</TD></TR><TR><TD>220183</TD><TD>9Z1</TD><TD><STRONG>BLANK</STRONG></TD></TR><TR><TD>240522</TD><TD>9Z1</TD><TD><STRONG>BLANK</STRONG></TD></TR></TBODY></TABLE><P><BR />I've tried FILTER and Lookupvalue, but it ends up filtering the resulting visual so that only the matches show and the blanks are removed. Please help! Thank you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P> Tue, 13 Jun 2023 23:32:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pull-in-value-based-on-multiple-criteria-from-one-table-to/m-p/3282505#M157268 mish2212 2023-06-13T23:32:38Z