topic Measure not counting in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-not-counting/m-p/3990937#M154789 <P>Afternoon,</P><P>&nbsp;</P><P>I have 2 measures that calculate if one is above or below the other.<BR /><BR /></P><P>I can get this far but for some reason it wont total the 'Movement (Up)' or Movement(Down) measures and the 'Movement (Up)' is counting all rows not just the ones that match the criteria.</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">Movement (Down) = Var _Current = CALCULATE(Average('Table1'[Result]),FILTER('Table1','Table1'[Collection]="Current")) Var _Previous = CALCULATE(Average('Table1'[Result]),REMOVEFILTERS('Table1'[Collection]),'Table1'[Collection]=("Previouse")) RETURN CONVERT(CALCULATE(COUNTA('Table1'[Anon]),FILTER('Table1',_Current&gt;_Previous)),INTEGER)</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Example data</P><P>Table1&nbsp;</P><TABLE><TBODY><TR><TD>Anon</TD><TD>Result</TD><TD>Collection</TD></TR><TR><TD>Pupil 3281</TD><TD>28</TD><TD>Current</TD></TR><TR><TD>Pupil 3456</TD><TD>60</TD><TD>Current</TD></TR><TR><TD>Pupil 3508</TD><TD>28</TD><TD>Current</TD></TR><TR><TD>Pupil 3509</TD><TD>26</TD><TD>Current</TD></TR><TR><TD>Pupil 3592</TD><TD>39</TD><TD>Current</TD></TR><TR><TD>Pupil 3606</TD><TD>50</TD><TD>Current</TD></TR><TR><TD>Pupil 3628</TD><TD>28</TD><TD>Current</TD></TR><TR><TD>Pupil 3635</TD><TD>13</TD><TD>Current</TD></TR><TR><TD>Pupil 3671</TD><TD>69</TD><TD>Current</TD></TR><TR><TD>Pupil 3753</TD><TD>54</TD><TD>Current</TD></TR><TR><TD>Pupil 3815</TD><TD>64</TD><TD>Current</TD></TR><TR><TD>Pupil 3827</TD><TD>35</TD><TD>Current</TD></TR><TR><TD>Pupil 3828</TD><TD>58</TD><TD>Current</TD></TR><TR><TD>Pupil 3881</TD><TD>-27</TD><TD>Current</TD></TR><TR><TD>Pupil 3912</TD><TD>54</TD><TD>Current</TD></TR><TR><TD>Pupil 3918</TD><TD>26</TD><TD>Current</TD></TR><TR><TD>Pupil 3954</TD><TD>-93</TD><TD>Current</TD></TR><TR><TD>Pupil 3969</TD><TD>72</TD><TD>Current</TD></TR><TR><TD>Pupil 3998</TD><TD>20</TD><TD>Current</TD></TR><TR><TD>Pupil 4031</TD><TD>-42</TD><TD>Current</TD></TR><TR><TD>Pupil 4114</TD><TD>67</TD><TD>Current</TD></TR><TR><TD>Pupil 4338</TD><TD>27</TD><TD>Current</TD></TR><TR><TD>Pupil 4369</TD><TD>33</TD><TD>Current</TD></TR><TR><TD>Pupil 4462</TD><TD>83</TD><TD>Current</TD></TR><TR><TD>Pupil 3309</TD><TD>-3</TD><TD>Current</TD></TR><TR><TD>Pupil 3330</TD><TD>-46</TD><TD>Current</TD></TR><TR><TD>Pupil 3725</TD><TD>3</TD><TD>Current</TD></TR><TR><TD>Pupil 4236</TD><TD>&nbsp;</TD><TD>Current</TD></TR><TR><TD>Pupil 4450</TD><TD>34</TD><TD>Current</TD></TR><TR><TD>Pupil 4464</TD><TD>10</TD><TD>Current</TD></TR><TR><TD>Pupil 3281</TD><TD>-1</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3456</TD><TD>43</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3508</TD><TD>23</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3509</TD><TD>-5</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3592</TD><TD>29</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3606</TD><TD>36</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3628</TD><TD>13</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3635</TD><TD>-11</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3671</TD><TD>28</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3753</TD><TD>16</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3815</TD><TD>61</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3827</TD><TD>34</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3828</TD><TD>22</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3881</TD><TD>-46</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3912</TD><TD>48</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3918</TD><TD>-2</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3954</TD><TD>-105</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3969</TD><TD>54</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3998</TD><TD>6</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4031</TD><TD>-65</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4114</TD><TD>42</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4338</TD><TD>16</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4369</TD><TD>-44</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4462</TD><TD>72</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3309</TD><TD>3</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3330</TD><TD>-36</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3725</TD><TD>37</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4236</TD><TD>57</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4450</TD><TD>37</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4464</TD><TD>34</TD><TD>Previouse</TD></TR></TBODY></TABLE><P>&nbsp;</P> Thu, 13 Jun 2024 11:09:50 GMT CEllis 2024-06-13T11:09:50Z Measure not counting https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-not-counting/m-p/3990937#M154789 <P>Afternoon,</P><P>&nbsp;</P><P>I have 2 measures that calculate if one is above or below the other.<BR /><BR /></P><P>I can get this far but for some reason it wont total the 'Movement (Up)' or Movement(Down) measures and the 'Movement (Up)' is counting all rows not just the ones that match the criteria.</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">Movement (Down) = Var _Current = CALCULATE(Average('Table1'[Result]),FILTER('Table1','Table1'[Collection]="Current")) Var _Previous = CALCULATE(Average('Table1'[Result]),REMOVEFILTERS('Table1'[Collection]),'Table1'[Collection]=("Previouse")) RETURN CONVERT(CALCULATE(COUNTA('Table1'[Anon]),FILTER('Table1',_Current&gt;_Previous)),INTEGER)</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Example data</P><P>Table1&nbsp;</P><TABLE><TBODY><TR><TD>Anon</TD><TD>Result</TD><TD>Collection</TD></TR><TR><TD>Pupil 3281</TD><TD>28</TD><TD>Current</TD></TR><TR><TD>Pupil 3456</TD><TD>60</TD><TD>Current</TD></TR><TR><TD>Pupil 3508</TD><TD>28</TD><TD>Current</TD></TR><TR><TD>Pupil 3509</TD><TD>26</TD><TD>Current</TD></TR><TR><TD>Pupil 3592</TD><TD>39</TD><TD>Current</TD></TR><TR><TD>Pupil 3606</TD><TD>50</TD><TD>Current</TD></TR><TR><TD>Pupil 3628</TD><TD>28</TD><TD>Current</TD></TR><TR><TD>Pupil 3635</TD><TD>13</TD><TD>Current</TD></TR><TR><TD>Pupil 3671</TD><TD>69</TD><TD>Current</TD></TR><TR><TD>Pupil 3753</TD><TD>54</TD><TD>Current</TD></TR><TR><TD>Pupil 3815</TD><TD>64</TD><TD>Current</TD></TR><TR><TD>Pupil 3827</TD><TD>35</TD><TD>Current</TD></TR><TR><TD>Pupil 3828</TD><TD>58</TD><TD>Current</TD></TR><TR><TD>Pupil 3881</TD><TD>-27</TD><TD>Current</TD></TR><TR><TD>Pupil 3912</TD><TD>54</TD><TD>Current</TD></TR><TR><TD>Pupil 3918</TD><TD>26</TD><TD>Current</TD></TR><TR><TD>Pupil 3954</TD><TD>-93</TD><TD>Current</TD></TR><TR><TD>Pupil 3969</TD><TD>72</TD><TD>Current</TD></TR><TR><TD>Pupil 3998</TD><TD>20</TD><TD>Current</TD></TR><TR><TD>Pupil 4031</TD><TD>-42</TD><TD>Current</TD></TR><TR><TD>Pupil 4114</TD><TD>67</TD><TD>Current</TD></TR><TR><TD>Pupil 4338</TD><TD>27</TD><TD>Current</TD></TR><TR><TD>Pupil 4369</TD><TD>33</TD><TD>Current</TD></TR><TR><TD>Pupil 4462</TD><TD>83</TD><TD>Current</TD></TR><TR><TD>Pupil 3309</TD><TD>-3</TD><TD>Current</TD></TR><TR><TD>Pupil 3330</TD><TD>-46</TD><TD>Current</TD></TR><TR><TD>Pupil 3725</TD><TD>3</TD><TD>Current</TD></TR><TR><TD>Pupil 4236</TD><TD>&nbsp;</TD><TD>Current</TD></TR><TR><TD>Pupil 4450</TD><TD>34</TD><TD>Current</TD></TR><TR><TD>Pupil 4464</TD><TD>10</TD><TD>Current</TD></TR><TR><TD>Pupil 3281</TD><TD>-1</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3456</TD><TD>43</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3508</TD><TD>23</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3509</TD><TD>-5</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3592</TD><TD>29</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3606</TD><TD>36</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3628</TD><TD>13</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3635</TD><TD>-11</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3671</TD><TD>28</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3753</TD><TD>16</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3815</TD><TD>61</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3827</TD><TD>34</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3828</TD><TD>22</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3881</TD><TD>-46</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3912</TD><TD>48</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3918</TD><TD>-2</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3954</TD><TD>-105</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3969</TD><TD>54</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3998</TD><TD>6</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4031</TD><TD>-65</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4114</TD><TD>42</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4338</TD><TD>16</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4369</TD><TD>-44</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4462</TD><TD>72</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3309</TD><TD>3</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3330</TD><TD>-36</TD><TD>Previouse</TD></TR><TR><TD>Pupil 3725</TD><TD>37</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4236</TD><TD>57</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4450</TD><TD>37</TD><TD>Previouse</TD></TR><TR><TD>Pupil 4464</TD><TD>34</TD><TD>Previouse</TD></TR></TBODY></TABLE><P>&nbsp;</P> Thu, 13 Jun 2024 11:09:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-not-counting/m-p/3990937#M154789 CEllis 2024-06-13T11:09:50Z Re: Measure not counting https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-not-counting/m-p/3991095#M154803 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="325066" data-lia-user-login="CEllis" class="lia-mention lia-mention-user">CEllis</a>&nbsp;First, please vote for this idea: <A href="https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e" target="_blank">https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e</A><BR /><BR />This looks like a measure totals problem. Very common. See my post about it here: <A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376" target="_blank">https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376</A><BR /><BR />Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:<BR /><A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907" target="_blank">https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907</A><BR /><BR />Also: <A href="https://youtu.be/uXRriTN0cfY" target="_blank">https://youtu.be/uXRriTN0cfY</A><BR />And: <A href="https://youtu.be/n4TYhF2ARe8" target="_blank">https://youtu.be/n4TYhF2ARe8</A></P> Thu, 13 Jun 2024 12:47:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-not-counting/m-p/3991095#M154803 Greg_Deckler 2024-06-13T12:47:37Z Re: Measure not counting https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-not-counting/m-p/3992259#M154946 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="325066" data-lia-user-login="CEllis" class="lia-mention lia-mention-user">CEllis</a>&nbsp;,</P> <P>I create a table as you mentioned.</P> <P><img /></P> <P>Maybe I think you can use this calculated column, here is the DAX code.</P> <LI-CODE lang="markup">Column = IF('Table'[Current]&gt;'Table'[Previous],"Current","Previous")</LI-CODE> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN>Best Regards</SPAN></P> <P><SPAN>Yilong Zhou</SPAN></P> <P><SPAN>If this post&nbsp;<STRONG><I>helps</I></STRONG>, then please consider&nbsp;<STRONG><I>Accept it as the solution</I></STRONG>&nbsp;to help the other members find it more quickly.</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 14 Jun 2024 02:39:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-not-counting/m-p/3992259#M154946 Anonymous 2024-06-14T02:39:21Z