https://community.fabric.microsoft.com/t5/s/yrjkf47658/tracker ac_clynk Tracker Fri, 18 Sep 2026 21:07:48 GMT 2026-09-18T21:07:48Z https://community.fabric.microsoft.com/t5/Desktop/Distinct-and-MAX-as-filters-in-query/m-p/485776#M226224 <P>Hi Raj,</P><P>&nbsp;</P><P>For some reason, this solution wasn't as clear until I read your answer to another request:</P><P><A href="https://community.powerbi.com/t5/Desktop/Getting-the-Max-value-of-each-group/m-p/485735#M226201" target="_blank">https://community.powerbi.com/t5/Desktop/Getting-the-Max-value-of-each-group/m-p/485735#M226201</A></P><P>&nbsp;</P><P>Combining these two instructions worked for me.&nbsp;&nbsp; I was trying to emulate the Teams status of members in the Harvest time tracking system.&nbsp; Many thanks.</P> Fri, 10 Aug 2018 00:33:38 GMT https://community.fabric.microsoft.com/t5/Desktop/Distinct-and-MAX-as-filters-in-query/m-p/485776#M226224 ac_clynk 2018-08-10T00:33:38Z https://community.fabric.microsoft.com/t5/Desktop/Distinct-and-MAX-as-filters-in-query/m-p/484540#M225619 <P>Hi there.&nbsp; My google fu is letting me down.</P><P>&nbsp;</P><P>I'm accessing a web API and returning 100 records.</P><P>I only care to get distinct user; distinct(user), and the record with highes value for number; max(number)</P><P>For instance:</P><P>&nbsp;</P><P>user&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; number&nbsp;&nbsp;&nbsp;&nbsp; content</P><P>joe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; blah</P><P>jim&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; blah</P><P>joe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; blah</P><P>jon&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; blah</P><P>jim&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; blah</P><P>&nbsp;</P><P>What I'd like to have returned is:</P><P>&nbsp;</P><P>joe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; blah</P><P>jim&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; blah</P><P>jon&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; blah</P><P>&nbsp;</P><P>How am I to only return that?&nbsp;</P><P>&nbsp;</P><P>Much appreciated!</P> Thu, 09 Aug 2018 00:43:25 GMT https://community.fabric.microsoft.com/t5/Desktop/Distinct-and-MAX-as-filters-in-query/m-p/484540#M225619 ac_clynk 2018-08-09T00:43:25Z