topic Re: Average on selected Value in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3153626#M113040 <P><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;One to Many relationship with single filter of product.</P> Sat, 25 Mar 2023 02:41:34 GMT arvindarvind24 2023-03-25T02:41:34Z Average on selected Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3149623#M112789 <P>Hi,</P><P>&nbsp;</P><P>&nbsp; Need to calcuate&nbsp;Average on selected Value.<BR /><BR /></P><TABLE><TBODY><TR><TD>Product</TD><TD>Style No</TD><TD>Sale Qty</TD><TD>Avg Sales Qty</TD><TD>Sales Qty/ Avg Sales Qty</TD></TR><TR><TD>CD SET</TD><TD>1</TD><TD>30</TD><TD>6.26</TD><TD>4.79</TD></TR><TR><TD>CD SET</TD><TD>2</TD><TD>28</TD><TD>6.26</TD><TD>4.47</TD></TR><TR><TD>CD SET</TD><TD>3</TD><TD>14</TD><TD>6.26</TD><TD>2.24</TD></TR><TR><TD>CD SET</TD><TD>4</TD><TD>13</TD><TD>6.26</TD><TD>2.08</TD></TR><TR><TD>CD SET</TD><TD>5</TD><TD>11</TD><TD>6.26</TD><TD>1.76</TD></TR><TR><TD>CD SET</TD><TD>6</TD><TD>9</TD><TD>6.26</TD><TD>1.44</TD></TR><TR><TD>CD SET</TD><TD>7</TD><TD>8</TD><TD>6.26</TD><TD>1.28</TD></TR><TR><TD>CD SET</TD><TD>8</TD><TD>7</TD><TD>6.26</TD><TD>1.12</TD></TR><TR><TD>CD SET</TD><TD>9</TD><TD>7</TD><TD>6.26</TD><TD>1.12</TD></TR><TR><TD>CD SET</TD><TD>10</TD><TD>6</TD><TD>6.26</TD><TD>0.96</TD></TR><TR><TD>CD SET</TD><TD>11</TD><TD>6</TD><TD>6.26</TD><TD>0.96</TD></TR><TR><TD>CD SET</TD><TD>12</TD><TD>5</TD><TD>6.26</TD><TD>0.80</TD></TR><TR><TD>CD SET</TD><TD>13</TD><TD>5</TD><TD>6.26</TD><TD>0.80</TD></TR><TR><TD>CD SET</TD><TD>14</TD><TD>4</TD><TD>6.26</TD><TD>0.64</TD></TR><TR><TD>CD SET</TD><TD>15</TD><TD>4</TD><TD>6.26</TD><TD>0.64</TD></TR><TR><TD>CD SET</TD><TD>16</TD><TD>4</TD><TD>6.26</TD><TD>0.64</TD></TR><TR><TD>CD SET</TD><TD>17</TD><TD>4</TD><TD>6.26</TD><TD>0.64</TD></TR><TR><TD>CD SET</TD><TD>18</TD><TD>4</TD><TD>6.26</TD><TD>0.64</TD></TR><TR><TD>CD SET</TD><TD>19</TD><TD>4</TD><TD>6.26</TD><TD>0.64</TD></TR><TR><TD>CD SET</TD><TD>20</TD><TD>3</TD><TD>6.26</TD><TD>0.48</TD></TR><TR><TD>CD SET</TD><TD>21</TD><TD>3</TD><TD>6.26</TD><TD>0.48</TD></TR><TR><TD>CD SET</TD><TD>22</TD><TD>3</TD><TD>6.26</TD><TD>0.48</TD></TR><TR><TD>CD SET</TD><TD>23</TD><TD>3</TD><TD>6.26</TD><TD>0.48</TD></TR><TR><TD>CD SET</TD><TD>24</TD><TD>3</TD><TD>6.26</TD><TD>0.48</TD></TR><TR><TD>CD SET</TD><TD>25</TD><TD>3</TD><TD>6.26</TD><TD>0.48</TD></TR><TR><TD>CD SET</TD><TD>26</TD><TD>3</TD><TD>6.26</TD><TD>0.48</TD></TR><TR><TD>CD SET</TD><TD>27</TD><TD>3</TD><TD>6.26</TD><TD>0.48</TD></TR><TR><TD>CD SET</TD><TD>28</TD><TD>3</TD><TD>6.26</TD><TD>0.48</TD></TR><TR><TD>CD SET</TD><TD>29</TD><TD>3</TD><TD>6.26</TD><TD>0.48</TD></TR><TR><TD>CD SET</TD><TD>30</TD><TD>2</TD><TD>6.26</TD><TD>0.32</TD></TR><TR><TD>CD SET</TD><TD>31</TD><TD>2</TD><TD>6.26</TD><TD>0.32</TD></TR><TR><TD>CD SET</TD><TD>32</TD><TD>2</TD><TD>6.26</TD><TD>0.32</TD></TR><TR><TD>CD SET</TD><TD>33</TD><TD>2</TD><TD>6.26</TD><TD>0.32</TD></TR><TR><TD>CD SET</TD><TD>34</TD><TD>2</TD><TD>6.26</TD><TD>0.32</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/68907" target="_blank" rel="noopener">@amitchauhan</A><SPAN>&nbsp;</SPAN><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/337836" target="_blank" rel="noopener">@bvanderwatt</A><SPAN>&nbsp;</SPAN><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/400021" target="_blank" rel="noopener">@ray_ux</A><SPAN>&nbsp;</SPAN><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/317289" target="_blank" rel="noopener">@tamerj1</A><SPAN>&nbsp;</SPAN><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/377293" target="_blank" rel="noopener">@SpartaBI</A><SPAN>&nbsp;</SPAN><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/341552" target="_blank" rel="noopener">@v-chenyue-msft&nbsp;&nbsp;</A><SPAN><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/453220" target="_blank" rel="noopener">@mangaus1111</A></SPAN></P><P><SPAN><A href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/51887" target="_blank" rel="noopener">@v-jianhe-msft</A>&nbsp;</SPAN></P> Thu, 23 Mar 2023 11:22:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3149623#M112789 arvindarvind24 2023-03-23T11:22:48Z Re: Average on selected Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151595#M112883 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="405861" data-lia-user-login="arvindarvind24" class="lia-mention lia-mention-user">arvindarvind24</a>&nbsp;<BR />Please elaborate more on the expected results</P> Fri, 24 Mar 2023 04:57:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151595#M112883 tamerj1 2023-03-24T04:57:44Z Re: Average on selected Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151614#M112888 <P>Hi&nbsp;<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;,<BR /><BR />Based on product i need the average.<BR /><BR /></P><TABLE><TBODY><TR><TD>Product</TD><TD>Size</TD><TD>Style No</TD><TD>Colour</TD><TD>Sale Qty</TD><TD>Avg Sales Qty</TD><TD>Sales Qty/ Avg Sales Qty</TD></TR><TR><TD>Product01</TD><TD>S</TD><TD>1</TD><TD>Red</TD><TD>30</TD><TD>12.63</TD><TD>2.38</TD></TR><TR><TD>Product01</TD><TD>M</TD><TD>2</TD><TD>Black</TD><TD>28</TD><TD>12.63</TD><TD>2.22</TD></TR><TR><TD>Product01</TD><TD>XL</TD><TD>3</TD><TD>Green</TD><TD>14</TD><TD>12.63</TD><TD>1.11</TD></TR><TR><TD>Product01</TD><TD>XXL</TD><TD>4</TD><TD>Red</TD><TD>13</TD><TD>12.63</TD><TD>1.03</TD></TR><TR><TD>Product01</TD><TD>S</TD><TD>5</TD><TD>Black</TD><TD>11</TD><TD>12.63</TD><TD>0.87</TD></TR><TR><TD>Product01</TD><TD>M</TD><TD>6</TD><TD>Green</TD><TD>9</TD><TD>12.63</TD><TD>0.71</TD></TR><TR><TD>Product01</TD><TD>XL</TD><TD>7</TD><TD>Red</TD><TD>8</TD><TD>12.63</TD><TD>0.63</TD></TR><TR><TD>Product01</TD><TD>XXL</TD><TD>8</TD><TD>Black</TD><TD>7</TD><TD>12.63</TD><TD>0.55</TD></TR><TR><TD>Product01</TD><TD>S</TD><TD>9</TD><TD>Green</TD><TD>7</TD><TD>12.63</TD><TD>0.55</TD></TR><TR><TD>Product01</TD><TD>M</TD><TD>10</TD><TD>Red</TD><TD>6</TD><TD>12.63</TD><TD>0.48</TD></TR><TR><TD>Product01</TD><TD>XL</TD><TD>11</TD><TD>Black</TD><TD>6</TD><TD>12.63</TD><TD>0.48</TD></TR><TR><TD>Product02</TD><TD>S</TD><TD>12</TD><TD>Green</TD><TD>5</TD><TD>3.83</TD><TD>1.31</TD></TR><TR><TD>Product02</TD><TD>M</TD><TD>13</TD><TD>Red</TD><TD>5</TD><TD>3.83</TD><TD>1.31</TD></TR><TR><TD>Product02</TD><TD>XL</TD><TD>14</TD><TD>Black</TD><TD>4</TD><TD>3.83</TD><TD>1.04</TD></TR><TR><TD>Product02</TD><TD>XXL</TD><TD>15</TD><TD>Green</TD><TD>4</TD><TD>3.83</TD><TD>1.04</TD></TR><TR><TD>Product02</TD><TD>S</TD><TD>16</TD><TD>Red</TD><TD>4</TD><TD>3.83</TD><TD>1.04</TD></TR><TR><TD>Product02</TD><TD>M</TD><TD>17</TD><TD>Black</TD><TD>4</TD><TD>3.83</TD><TD>1.04</TD></TR><TR><TD>Product02</TD><TD>XL</TD><TD>18</TD><TD>Green</TD><TD>4</TD><TD>3.83</TD><TD>1.04</TD></TR><TR><TD>Product02</TD><TD>XXL</TD><TD>19</TD><TD>Red</TD><TD>4</TD><TD>3.83</TD><TD>1.04</TD></TR><TR><TD>Product02</TD><TD>S</TD><TD>20</TD><TD>Black</TD><TD>3</TD><TD>3.83</TD><TD>0.78</TD></TR><TR><TD>Product02</TD><TD>M</TD><TD>21</TD><TD>Green</TD><TD>3</TD><TD>3.83</TD><TD>0.78</TD></TR><TR><TD>Product02</TD><TD>XL</TD><TD>22</TD><TD>Red</TD><TD>3</TD><TD>3.83</TD><TD>0.78</TD></TR><TR><TD>Product02</TD><TD>S</TD><TD>23</TD><TD>Black</TD><TD>3</TD><TD>3.83</TD><TD>0.78</TD></TR><TR><TD>Product03</TD><TD>XL</TD><TD>24</TD><TD>Green</TD><TD>3</TD><TD>2.54</TD><TD>1.18</TD></TR><TR><TD>Product03</TD><TD>XXL</TD><TD>25</TD><TD>Red</TD><TD>3</TD><TD>2.54</TD><TD>1.18</TD></TR><TR><TD>Product03</TD><TD>S</TD><TD>26</TD><TD>Black</TD><TD>3</TD><TD>2.54</TD><TD>1.18</TD></TR><TR><TD>Product03</TD><TD>M</TD><TD>27</TD><TD>Green</TD><TD>3</TD><TD>2.54</TD><TD>1.18</TD></TR><TR><TD>Product03</TD><TD>XL</TD><TD>28</TD><TD>Red</TD><TD>3</TD><TD>2.54</TD><TD>1.18</TD></TR><TR><TD>Product03</TD><TD>XXL</TD><TD>29</TD><TD>Black</TD><TD>3</TD><TD>2.54</TD><TD>1.18</TD></TR><TR><TD>Product03</TD><TD>S</TD><TD>30</TD><TD>Green</TD><TD>2</TD><TD>2.54</TD><TD>0.79</TD></TR><TR><TD>Product03</TD><TD>M</TD><TD>31</TD><TD>Red</TD><TD>2</TD><TD>2.54</TD><TD>0.79</TD></TR><TR><TD>Product03</TD><TD>XL</TD><TD>32</TD><TD>Black</TD><TD>2</TD><TD>2.54</TD><TD>0.79</TD></TR><TR><TD>Product03</TD><TD>M</TD><TD>33</TD><TD>Green</TD><TD>2</TD><TD>2.54</TD><TD>0.79</TD></TR><TR><TD>Product03</TD><TD>M</TD><TD>34</TD><TD>Red</TD><TD>2</TD><TD>2.54</TD><TD>0.79</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>Product</TD><TD>Sales Qty</TD><TD>Avg Value</TD></TR><TR><TD>Product01</TD><TD>139</TD><TD>12.63</TD></TR><TR><TD>Product02</TD><TD>46</TD><TD>3.83</TD></TR><TR><TD>Product03</TD><TD>28</TD><TD>2.54</TD></TR></TBODY></TABLE> Fri, 24 Mar 2023 05:28:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151614#M112888 arvindarvind24 2023-03-24T05:28:56Z Re: Average on selected Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151747#M112899 <P>FYI.<BR /><BR /></P><TABLE><TBODY><TR><TD>Table1</TD><TD>Table1</TD><TD>Table1</TD><TD>Table1</TD><TD>Table2</TD><TD><FONT color="#FF9900">Based on Product I need the Avg (Result Required)</FONT></TD></TR><TR><TD>Product</TD><TD>Size</TD><TD>Style No</TD><TD>Colour</TD><TD>Sale Qty</TD><TD><FONT color="#FF9900">Avg Sales Qty</FONT></TD></TR><TR><TD>Product01</TD><TD>S</TD><TD>1</TD><TD>Red</TD><TD>30</TD><TD><FONT color="#FF9900">12.63</FONT></TD></TR><TR><TD>Product01</TD><TD>M</TD><TD>2</TD><TD>Black</TD><TD>28</TD><TD><FONT color="#FF9900">12.63</FONT></TD></TR><TR><TD>Product01</TD><TD>XL</TD><TD>3</TD><TD>Green</TD><TD>14</TD><TD><FONT color="#FF9900">12.63</FONT></TD></TR><TR><TD>Product01</TD><TD>XXL</TD><TD>4</TD><TD>Red</TD><TD>13</TD><TD><FONT color="#FF9900">12.63</FONT></TD></TR><TR><TD>Product01</TD><TD>S</TD><TD>5</TD><TD>Black</TD><TD>11</TD><TD><FONT color="#FF9900">12.63</FONT></TD></TR><TR><TD>Product01</TD><TD>M</TD><TD>6</TD><TD>Green</TD><TD>9</TD><TD><FONT color="#FF9900">12.63</FONT></TD></TR><TR><TD>Product01</TD><TD>XL</TD><TD>7</TD><TD>Red</TD><TD>8</TD><TD><FONT color="#FF9900">12.63</FONT></TD></TR><TR><TD>Product01</TD><TD>XXL</TD><TD>8</TD><TD>Black</TD><TD>7</TD><TD><FONT color="#FF9900">12.63</FONT></TD></TR><TR><TD>Product01</TD><TD>S</TD><TD>9</TD><TD>Green</TD><TD>7</TD><TD><FONT color="#FF9900">12.63</FONT></TD></TR><TR><TD>Product01</TD><TD>M</TD><TD>10</TD><TD>Red</TD><TD>6</TD><TD><FONT color="#FF9900">12.63</FONT></TD></TR><TR><TD>Product01</TD><TD>XL</TD><TD>11</TD><TD>Black</TD><TD>6</TD><TD><FONT color="#FF9900">12.63</FONT></TD></TR><TR><TD>Product02</TD><TD>S</TD><TD>12</TD><TD>Green</TD><TD>5</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product02</TD><TD>M</TD><TD>13</TD><TD>Red</TD><TD>5</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product02</TD><TD>XL</TD><TD>14</TD><TD>Black</TD><TD>4</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product02</TD><TD>XXL</TD><TD>15</TD><TD>Green</TD><TD>4</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product02</TD><TD>S</TD><TD>16</TD><TD>Red</TD><TD>4</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product02</TD><TD>M</TD><TD>17</TD><TD>Black</TD><TD>4</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product02</TD><TD>XL</TD><TD>18</TD><TD>Green</TD><TD>4</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product02</TD><TD>XXL</TD><TD>19</TD><TD>Red</TD><TD>4</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product02</TD><TD>S</TD><TD>20</TD><TD>Black</TD><TD>3</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product02</TD><TD>M</TD><TD>21</TD><TD>Green</TD><TD>3</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product02</TD><TD>XL</TD><TD>22</TD><TD>Red</TD><TD>3</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product02</TD><TD>S</TD><TD>23</TD><TD>Black</TD><TD>3</TD><TD><FONT color="#FF9900">3.83</FONT></TD></TR><TR><TD>Product03</TD><TD>XL</TD><TD>24</TD><TD>Green</TD><TD>3</TD><TD><FONT color="#FF9900">2.54</FONT></TD></TR><TR><TD>Product03</TD><TD>XXL</TD><TD>25</TD><TD>Red</TD><TD>3</TD><TD><FONT color="#FF9900">2.54</FONT></TD></TR><TR><TD>Product03</TD><TD>S</TD><TD>26</TD><TD>Black</TD><TD>3</TD><TD><FONT color="#FF9900">2.54</FONT></TD></TR><TR><TD>Product03</TD><TD>M</TD><TD>27</TD><TD>Green</TD><TD>3</TD><TD><FONT color="#FF9900">2.54</FONT></TD></TR><TR><TD>Product03</TD><TD>XL</TD><TD>28</TD><TD>Red</TD><TD>3</TD><TD><FONT color="#FF9900">2.54</FONT></TD></TR><TR><TD>Product03</TD><TD>XXL</TD><TD>29</TD><TD>Black</TD><TD>3</TD><TD><FONT color="#FF9900">2.54</FONT></TD></TR><TR><TD>Product03</TD><TD>S</TD><TD>30</TD><TD>Green</TD><TD>2</TD><TD><FONT color="#FF9900">2.54</FONT></TD></TR><TR><TD>Product03</TD><TD>M</TD><TD>31</TD><TD>Red</TD><TD>2</TD><TD><FONT color="#FF9900">2.54</FONT></TD></TR><TR><TD>Product03</TD><TD>XL</TD><TD>32</TD><TD>Black</TD><TD>2</TD><TD><FONT color="#FF9900">2.54</FONT></TD></TR><TR><TD>Product03</TD><TD>M</TD><TD>33</TD><TD>Green</TD><TD>2</TD><TD><FONT color="#FF9900">2.54</FONT></TD></TR><TR><TD>Product03</TD><TD>M</TD><TD>34</TD><TD>Red</TD><TD>2</TD><TD><FONT color="#FF9900">2.54</FONT></TD></TR></TBODY></TABLE> Fri, 24 Mar 2023 07:05:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151747#M112899 arvindarvind24 2023-03-24T07:05:41Z Re: Average on selected Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151753#M112900 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="405861" data-lia-user-login="arvindarvind24" class="lia-mention lia-mention-user">arvindarvind24</a>&nbsp;<BR />How are table1 and Table2 connected? Are looking for a measure or a calculated column?</P> Fri, 24 Mar 2023 07:08:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151753#M112900 tamerj1 2023-03-24T07:08:05Z Re: Average on selected Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151765#M112904 <P><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;<SPAN>There are connected through the icode relationship and am looking for measure.</SPAN></P> Fri, 24 Mar 2023 07:11:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151765#M112904 arvindarvind24 2023-03-24T07:11:33Z Re: Average on selected Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151768#M112905 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="405861" data-lia-user-login="arvindarvind24" class="lia-mention lia-mention-user">arvindarvind24</a>&nbsp;<BR />What kind of relationship? Which filters which?</P> Fri, 24 Mar 2023 07:13:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151768#M112905 tamerj1 2023-03-24T07:13:02Z Re: Average on selected Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151778#M112906 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="405861" data-lia-user-login="arvindarvind24" class="lia-mention lia-mention-user">arvindarvind24</a>&nbsp;<BR />However, please try</P> <LI-CODE lang="javascript">Avg Sales Qty = CALCULATE ( AVERAGE ( Table2[Sales Qty] ), ALLEXCEPT ( Table1, Table1[Produvt] ) )</LI-CODE> Fri, 24 Mar 2023 07:17:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3151778#M112906 tamerj1 2023-03-24T07:17:56Z Re: Average on selected Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3153626#M113040 <P><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;One to Many relationship with single filter of product.</P> Sat, 25 Mar 2023 02:41:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3153626#M113040 arvindarvind24 2023-03-25T02:41:34Z Re: Average on selected Value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3155314#M113153 <P>Hi All,<BR />&nbsp; After using the&nbsp;<SPAN>ALLEXCEPT the value is not getting.</SPAN></P><P><BR /><img /></P><P>&nbsp;</P><P>Result Wanted:<BR /><img /></P><P>&nbsp;</P> Mon, 27 Mar 2023 07:15:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-on-selected-Value/m-p/3155314#M113153 arvindarvind24 2023-03-27T07:15:50Z