topic Average of dynamic percentage in DAX Commands and Tips

topic Average of dynamic percentage in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-dynamic-percentage/m-p/3573129#M137762 <P>I need to figure out how to calculate average of the percentage. </P><P>I have a matrix table below. I need average of the percentage of all Categories per Label.</P><P> </P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Label</TD><TD>Label 1</TD><TD>Label 2</TD><TD>Label 3</TD><TD>Label 4</TD><TD>Total</TD></TR><TR><TD>Category</TD><TD>IDs</TD><TD>IDs %</TD><TD>IDs</TD><TD>IDs %</TD><TD>IDs</TD><TD>IDs %</TD><TD>IDs</TD><TD>IDs %</TD><TD>IDs</TD><TD>IDs %</TD></TR><TR><TD>A</TD><TD>96</TD><TD>20.1%</TD><TD>134</TD><TD>28.1%</TD><TD>29</TD><TD>6.1%</TD><TD>218</TD><TD>45.7%</TD><TD>477</TD><TD>100.0%</TD></TR><TR><TD>B</TD><TD>62</TD><TD>24.9%</TD><TD>37</TD><TD>14.9%</TD><TD>4</TD><TD>1.6%</TD><TD>146</TD><TD>58.6%</TD><TD>249</TD><TD>100.0%</TD></TR><TR><TD>C</TD><TD>200</TD><TD>21.5%</TD><TD>165</TD><TD>17.7%</TD><TD>48</TD><TD>5.2%</TD><TD>519</TD><TD>55.7%</TD><TD>932</TD><TD>100.0%</TD></TR><TR><TD>D</TD><TD>70</TD><TD>29.9%</TD><TD>26</TD><TD>11.1%</TD><TD>3</TD><TD>1.3%</TD><TD>135</TD><TD>57.7%</TD><TD>234</TD><TD>100.0%</TD></TR><TR><TD>Total</TD><TD>270</TD><TD>17.0%</TD><TD>348</TD><TD>21.9%</TD><TD>75</TD><TD>4.7%</TD><TD>895</TD><TD>56.4%</TD><TD>1588</TD><TD>100.0%</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Needed</TD><TD> </TD><TD>24.1%</TD><TD> </TD><TD>17.9%</TD><TD> </TD><TD>3.5%</TD><TD> </TD><TD>54.4%</TD><TD> </TD><TD>100.0%</TD></TR></TBODY></TABLE><P> </P> Thu, 07 Dec 2023 17:53:57 GMT bharosha 2023-12-07T17:53:57Z Average of dynamic percentage https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-dynamic-percentage/m-p/3573129#M137762 <P>I need to figure out how to calculate average of the percentage. </P><P>I have a matrix table below. I need average of the percentage of all Categories per Label.</P><P> </P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Label</TD><TD>Label 1</TD><TD>Label 2</TD><TD>Label 3</TD><TD>Label 4</TD><TD>Total</TD></TR><TR><TD>Category</TD><TD>IDs</TD><TD>IDs %</TD><TD>IDs</TD><TD>IDs %</TD><TD>IDs</TD><TD>IDs %</TD><TD>IDs</TD><TD>IDs %</TD><TD>IDs</TD><TD>IDs %</TD></TR><TR><TD>A</TD><TD>96</TD><TD>20.1%</TD><TD>134</TD><TD>28.1%</TD><TD>29</TD><TD>6.1%</TD><TD>218</TD><TD>45.7%</TD><TD>477</TD><TD>100.0%</TD></TR><TR><TD>B</TD><TD>62</TD><TD>24.9%</TD><TD>37</TD><TD>14.9%</TD><TD>4</TD><TD>1.6%</TD><TD>146</TD><TD>58.6%</TD><TD>249</TD><TD>100.0%</TD></TR><TR><TD>C</TD><TD>200</TD><TD>21.5%</TD><TD>165</TD><TD>17.7%</TD><TD>48</TD><TD>5.2%</TD><TD>519</TD><TD>55.7%</TD><TD>932</TD><TD>100.0%</TD></TR><TR><TD>D</TD><TD>70</TD><TD>29.9%</TD><TD>26</TD><TD>11.1%</TD><TD>3</TD><TD>1.3%</TD><TD>135</TD><TD>57.7%</TD><TD>234</TD><TD>100.0%</TD></TR><TR><TD>Total</TD><TD>270</TD><TD>17.0%</TD><TD>348</TD><TD>21.9%</TD><TD>75</TD><TD>4.7%</TD><TD>895</TD><TD>56.4%</TD><TD>1588</TD><TD>100.0%</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Needed</TD><TD> </TD><TD>24.1%</TD><TD> </TD><TD>17.9%</TD><TD> </TD><TD>3.5%</TD><TD> </TD><TD>54.4%</TD><TD> </TD><TD>100.0%</TD></TR></TBODY></TABLE><P> </P> Thu, 07 Dec 2023 17:53:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-dynamic-percentage/m-p/3573129#M137762 bharosha 2023-12-07T17:53:57Z Re: Average of dynamic percentage https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-dynamic-percentage/m-p/3575887#M137861 <P>Your total numbers look off.  Do you have another filter?</P> <P> </P> <P><img /></P> <P> </P> Sun, 10 Dec 2023 01:45:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-dynamic-percentage/m-p/3575887#M137861 lbendlin 2023-12-10T01:45:30Z