topic Re: Average of distinct count in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-distinct-count/m-p/2501871#M69178 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="240987" data-lia-user-login="johnt75" class="lia-mention lia-mention-user">johnt75</a>&nbsp;thank you for the prompt response, results look much better. Appreciate your help.</P> Mon, 09 May 2022 11:42:25 GMT Anonymous 2022-05-09T11:42:25Z Average of distinct count https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-distinct-count/m-p/2501831#M69175 <P>I need a measure to calculate the average (distinct count of) tickets per site code as per visual below. I tried averagex, averagea but with incorrect results. Any tips please <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp;?</P><P><img /></P> Mon, 09 May 2022 11:21:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-distinct-count/m-p/2501831#M69175 Anonymous 2022-05-09T11:21:41Z Re: Average of distinct count https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-distinct-count/m-p/2501845#M69177 <LI-CODE lang="markup">Avg tickets = var summaryTable = ADDCOLUMNS( VALUES( 'Table'[SITE_CODE]), "@val", [Distinct total tickets]) return AVERAGEX( summaryTable, [@val])</LI-CODE> Mon, 09 May 2022 11:30:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-distinct-count/m-p/2501845#M69177 johnt75 2022-05-09T11:30:59Z Re: Average of distinct count https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-distinct-count/m-p/2501871#M69178 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="240987" data-lia-user-login="johnt75" class="lia-mention lia-mention-user">johnt75</a>&nbsp;thank you for the prompt response, results look much better. Appreciate your help.</P> Mon, 09 May 2022 11:42:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-distinct-count/m-p/2501871#M69178 Anonymous 2022-05-09T11:42:25Z