topic Re: Help with Dax in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Dax/m-p/3249353#M119847 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="539309" data-lia-user-login="jengnz" class="lia-mention lia-mention-user">jengnz</a>&nbsp;</P> <P>please try</P> <P>SUMX (</P> <P>VALUES ( 'Table'[Case Number] ),</P> <P>CALCULATE ( MAX (&nbsp;<SPAN>'Table'[Total Critical Errors] ) )</SPAN></P> <P><SPAN>)</SPAN></P> Tue, 23 May 2023 16:35:09 GMT tamerj1 2023-05-23T16:35:09Z Help with Dax https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Dax/m-p/3249258#M119840 <P>Trying to figure out a measure to get the Case number and the Critical errors.&nbsp; So I need Case Number 1 with 7 critical errors not 21 critical errors.&nbsp; The Total Critical Errors column is the total but it is showing for each row.&nbsp; Thank you</P><TABLE border="1"><TBODY><TR><TD>Case Number</TD><TD>Start date</TD><TD>Total Critical Errors</TD><TD>Total Non Critical errors</TD></TR><TR><TD>1</TD><TD>5/19/2023</TD><TD>7</TD><TD>11</TD></TR><TR><TD>1</TD><TD>5/19/2023</TD><TD>7</TD><TD>11</TD></TR><TR><TD>1</TD><TD>5/19/2023</TD><TD>7</TD><TD>11</TD></TR><TR><TD>2</TD><TD>5/18/2023</TD><TD>5</TD><TD>3</TD></TR><TR><TD>2</TD><TD>5/18/2023</TD><TD>5</TD><TD>3</TD></TR><TR><TD>3</TD><TD>5/19/2023</TD><TD>6</TD><TD>5</TD></TR><TR><TD>3</TD><TD>5/19/2023</TD><TD>6</TD><TD>5</TD></TR></TBODY></TABLE> Tue, 23 May 2023 15:38:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Dax/m-p/3249258#M119840 jengnz 2023-05-23T15:38:06Z Re: Help with Dax https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Dax/m-p/3249353#M119847 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="539309" data-lia-user-login="jengnz" class="lia-mention lia-mention-user">jengnz</a>&nbsp;</P> <P>please try</P> <P>SUMX (</P> <P>VALUES ( 'Table'[Case Number] ),</P> <P>CALCULATE ( MAX (&nbsp;<SPAN>'Table'[Total Critical Errors] ) )</SPAN></P> <P><SPAN>)</SPAN></P> Tue, 23 May 2023 16:35:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Dax/m-p/3249353#M119847 tamerj1 2023-05-23T16:35:09Z Re: Help with Dax https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Dax/m-p/3249635#M119863 <P>Worked perfectly! Thanks</P> Tue, 23 May 2023 19:36:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Dax/m-p/3249635#M119863 jengnz 2023-05-23T19:36:31Z