topic Re: Issue with DAX - Returns the same data against every record in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-DAX-Returns-the-same-data-against-every-record/m-p/3942948#M153275 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="747172" data-lia-user-login="mayurbajaj" class="lia-mention lia-mention-user">mayurbajaj</a>&nbsp;- you can try this:</P><P>&nbsp;</P><LI-CODE lang="markup">VAR meter = SELECTEDVALUE( 'Bill Header'[Site Meter Identifier] ) VAR account_num = SELECTEDVALUE( 'Bill Header'[Account Number] ) VAR calc = CALCULATE ( MAX ( 'Bill Header'[Bill Start Date] ), FILTER ( ALL ( 'Bill Header' ), 'Bill Header'[Site Meter Identifier] = meter, 'Bill Header'[Account Number] = account_num ) ) RETURN calc</LI-CODE><P>&nbsp;</P><P>If this works, please mark it as the solution.&nbsp;</P> Thu, 23 May 2024 09:49:43 GMT mark_endicott 2024-05-23T09:49:43Z Issue with DAX - Returns the same data against every record https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-DAX-Returns-the-same-data-against-every-record/m-p/3941679#M153250 <P>Actual Code:</P><DIV><DIV><SPAN>MaxStartDate =</SPAN></DIV><DIV><SPAN>MAXX</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>ADDCOLUMNS</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>SUMMARIZE</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>'Bill Header'</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>'Bill Header'</SPAN><SPAN>[Site Meter Identifier]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>'Bill Header'</SPAN><SPAN>[Account Number]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"MaxBillStartDate"</SPAN><SPAN>, </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>'Bill Header'</SPAN><SPAN>[Bill Start Date]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>[MaxBillStartDate]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Output</SPAN></DIV><DIV><img /><P>Its giving me the same Max Date against every record</P><P>Not too sure why?</P></DIV></DIV> Thu, 23 May 2024 06:09:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-DAX-Returns-the-same-data-against-every-record/m-p/3941679#M153250 mayurbajaj 2024-05-23T06:09:08Z Re: Issue with DAX - Returns the same data against every record https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-DAX-Returns-the-same-data-against-every-record/m-p/3942948#M153275 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="747172" data-lia-user-login="mayurbajaj" class="lia-mention lia-mention-user">mayurbajaj</a>&nbsp;- you can try this:</P><P>&nbsp;</P><LI-CODE lang="markup">VAR meter = SELECTEDVALUE( 'Bill Header'[Site Meter Identifier] ) VAR account_num = SELECTEDVALUE( 'Bill Header'[Account Number] ) VAR calc = CALCULATE ( MAX ( 'Bill Header'[Bill Start Date] ), FILTER ( ALL ( 'Bill Header' ), 'Bill Header'[Site Meter Identifier] = meter, 'Bill Header'[Account Number] = account_num ) ) RETURN calc</LI-CODE><P>&nbsp;</P><P>If this works, please mark it as the solution.&nbsp;</P> Thu, 23 May 2024 09:49:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-DAX-Returns-the-same-data-against-every-record/m-p/3942948#M153275 mark_endicott 2024-05-23T09:49:43Z