topic sum of last 10 values by one user in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sum-of-last-10-values-by-one-user/m-p/2725434#M83289 <P>Hello.</P><P>&nbsp;</P><P>I'm trying to create a calculated measure that would COUNT hasExtPower=TRUE for a certain PublicDeviceId. This measure must count only the last 10 entries (GpsTime DESC).</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>The output should look like this</P><P>&nbsp;</P><P>SN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Count of last 10 messages TRUE</P><P>29503&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5</P> Thu, 25 Aug 2022 08:49:30 GMT Domen 2022-08-25T08:49:30Z sum of last 10 values by one user https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sum-of-last-10-values-by-one-user/m-p/2725434#M83289 <P>Hello.</P><P>&nbsp;</P><P>I'm trying to create a calculated measure that would COUNT hasExtPower=TRUE for a certain PublicDeviceId. This measure must count only the last 10 entries (GpsTime DESC).</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>The output should look like this</P><P>&nbsp;</P><P>SN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Count of last 10 messages TRUE</P><P>29503&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5</P> Thu, 25 Aug 2022 08:49:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sum-of-last-10-values-by-one-user/m-p/2725434#M83289 Domen 2022-08-25T08:49:30Z Re: sum of last 10 values by one user https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sum-of-last-10-values-by-one-user/m-p/2725708#M83311 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="432228" data-lia-user-login="Domen" class="lia-mention lia-mention-user">Domen</a> , Create a rank column </P> <P>&nbsp;</P> <P>Rank GpsTime&nbsp; = rankx(Table, Table[GpsTime],,desc, dense)</P> <P>&nbsp;</P> <P>countrows(filter(Table, Table[Rank GpsTime ]&lt;= 10 &amp;&amp; [hasExtPower]=TRUE() ) )</P> Thu, 25 Aug 2022 10:11:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/sum-of-last-10-values-by-one-user/m-p/2725708#M83311 amitchandak 2022-08-25T10:11:26Z