topic Re: Need urgent help please!!! in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008944#M157943 <P>Ryan, the measure return the wrong value</P> Tue, 25 Jun 2024 10:35:03 GMT cuongtrinh2197 2024-06-25T10:35:03Z Need urgent help please!!! https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008714#M157939 <P>Hi, can someone show me the way to bring the field Customer part number to the visual table?</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Please find my attachment for details:<BR /><A href="https://shorturl.at/uI99n" target="_blank" rel="noopener">https://shorturl.at/uI99n</A></P> Tue, 25 Jun 2024 08:43:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008714#M157939 cuongtrinh2197 2024-06-25T08:43:08Z Re: Need urgent help please!!! https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008771#M157940 <P>i think you need to improve the data model.&nbsp;</P> <P>Now you can try to create a column</P> <P>&nbsp;</P> <DIV> <DIV><SPAN>customer part number =</SPAN> <SPAN>maxx</SPAN><SPAN>(</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>fCustProduct</SPAN><SPAN>,</SPAN><SPAN>fCustProduct</SPAN><SPAN>[Part number]</SPAN><SPAN>=</SPAN><SPAN>fSales</SPAN><SPAN>[Part number]</SPAN><SPAN>),</SPAN><SPAN>fCustProduct</SPAN><SPAN>[Customer Part Number]</SPAN><SPAN>)</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN><img /></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>then add this column to the table visual</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> </DIV> Tue, 25 Jun 2024 09:05:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008771#M157940 ryan_mayu 2024-06-25T09:05:20Z Re: Need urgent help please!!! https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008797#M157941 <P>Many thanks Ryan,<BR />Is there any chance for me to use your syntax acting as a measure?<BR />My company just empowered me to do the measure and visual table without modifying the dataset such as add a new column,...</P> Tue, 25 Jun 2024 09:18:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008797#M157941 cuongtrinh2197 2024-06-25T09:18:23Z Re: Need urgent help please!!! https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008881#M157942 <P>pls try this</P> <DIV> <DIV><SPAN>Measure</SPAN><SPAN> =</SPAN> <SPAN>maxx</SPAN><SPAN>(</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>fCustProduct</SPAN><SPAN>,</SPAN><SPAN>fCustProduct</SPAN><SPAN>[Part number]</SPAN><SPAN>=</SPAN><SPAN>max</SPAN><SPAN>(</SPAN><SPAN>fSales</SPAN><SPAN>[Part number]</SPAN><SPAN>)),</SPAN><SPAN>fCustProduct</SPAN><SPAN>[Customer Part Number]</SPAN><SPAN>)</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN><img /></SPAN></DIV> <DIV><SPAN>&nbsp;</SPAN></DIV> </DIV> Tue, 25 Jun 2024 09:56:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008881#M157942 ryan_mayu 2024-06-25T09:56:33Z Re: Need urgent help please!!! https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008944#M157943 <P>Ryan, the measure return the wrong value</P> Tue, 25 Jun 2024 10:35:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008944#M157943 cuongtrinh2197 2024-06-25T10:35:03Z Re: Need urgent help please!!! https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008948#M157944 <P>Sorry Ryan I just checked again, if you can see the measure return to the swrong result<BR />For example, line 1, customer 1 sale order but the return value in the measure column is the part number of customer 2</P> Tue, 25 Jun 2024 10:33:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4008948#M157944 cuongtrinh2197 2024-06-25T10:33:22Z Re: Need urgent help please!!! https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4010052#M157945 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="761300" data-lia-user-login="cuongtrinh2197" class="lia-mention lia-mention-user">cuongtrinh2197</a>&nbsp;</P> <P>pls see if this is what you want</P> <P>&nbsp;</P> <DIV> <DIV><SPAN>Measure</SPAN><SPAN> =</SPAN></DIV> <DIV><SPAN>VAR</SPAN> <SPAN>_cpn</SPAN><SPAN>=</SPAN><SPAN>maxx</SPAN><SPAN>(</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>fCustProduct</SPAN><SPAN>,</SPAN><SPAN>fCustProduct</SPAN><SPAN>[Part number]</SPAN><SPAN>=</SPAN><SPAN>max</SPAN><SPAN>(</SPAN><SPAN>fSales</SPAN><SPAN>[Part number]</SPAN><SPAN>)&amp;&amp; </SPAN><SPAN>fCustProduct</SPAN><SPAN>[Customer]</SPAN><SPAN>=</SPAN><SPAN>max</SPAN><SPAN>(</SPAN><SPAN>fSales</SPAN><SPAN>[Customer]</SPAN><SPAN>)),</SPAN><SPAN>fCustProduct</SPAN><SPAN>[Customer Part Number]</SPAN><SPAN>)</SPAN></DIV> <DIV><SPAN>return</SPAN> <SPAN>if</SPAN><SPAN> (</SPAN><SPAN>_cpn</SPAN><SPAN>=</SPAN><SPAN>""</SPAN><SPAN>,</SPAN><SPAN>max</SPAN><SPAN>(</SPAN><SPAN>fSales</SPAN><SPAN>[Part number]</SPAN><SPAN>),</SPAN><SPAN>_cpn</SPAN><SPAN>)</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN><img /></SPAN></DIV> </DIV> Wed, 26 Jun 2024 01:33:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-urgent-help-please/m-p/4010052#M157945 ryan_mayu 2024-06-26T01:33:27Z