https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/helping-with-DAX/m-p/2755663#M5111 <P>Hello guys , I need your help , to elaborate I included the table below&nbsp;</P><P>I have gategories ( Mobile-TV-Watches) that has average shipping delay per day ,&nbsp;</P><P>but in fact it is not correct for me , because for example in mobile category Samsung delay is 10 days, Apple is 15 , and nokia is 10 days , but in Average shipping culumn it gives me the sum of the average 35, and not the max which should be 15</P><P>how to solve this issue&nbsp;</P><P>&nbsp;</P><P>thanks in advance</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>category</TD><TD>Quantity</TD><TD>Average shipping delay per days</TD></TR><TR><TD>mobile</TD><TD>4</TD><TD>35</TD></TR><TR><TD>TV</TD><TD>3</TD><TD>64</TD></TR><TR><TD>Watches</TD><TD>4</TD><TD>33</TD></TR></TBODY></TABLE> Thu, 08 Sep 2022 13:27:30 GMT haniizz 2022-09-08T13:27:30Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/helping-with-DAX/m-p/2755663#M5111 <P>Hello guys , I need your help , to elaborate I included the table below&nbsp;</P><P>I have gategories ( Mobile-TV-Watches) that has average shipping delay per day ,&nbsp;</P><P>but in fact it is not correct for me , because for example in mobile category Samsung delay is 10 days, Apple is 15 , and nokia is 10 days , but in Average shipping culumn it gives me the sum of the average 35, and not the max which should be 15</P><P>how to solve this issue&nbsp;</P><P>&nbsp;</P><P>thanks in advance</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>category</TD><TD>Quantity</TD><TD>Average shipping delay per days</TD></TR><TR><TD>mobile</TD><TD>4</TD><TD>35</TD></TR><TR><TD>TV</TD><TD>3</TD><TD>64</TD></TR><TR><TD>Watches</TD><TD>4</TD><TD>33</TD></TR></TBODY></TABLE> Thu, 08 Sep 2022 13:27:30 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/helping-with-DAX/m-p/2755663#M5111 haniizz 2022-09-08T13:27:30Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/helping-with-DAX/m-p/2758272#M5120 <P>Please provide sanitized sample data that fully covers your issue. <A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> I can only help you with meaningful sample data.<BR />Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.<BR /><BR /><A href="https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Fri, 09 Sep 2022 13:13:05 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/helping-with-DAX/m-p/2758272#M5120 lbendlin 2022-09-09T13:13:05Z