https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-the-Percentile-of-a-Measure/m-p/3813561#M149146 <P>Hi,<BR /><BR />You can use PERCENTILEX functions to get this:<BR /><BR /></P> <DIV> <DIV><SPAN>Measure</SPAN> <SPAN>23</SPAN><SPAN> =</SPAN> <SPAN>PERCENTILEX.INC</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>'Table (32)'</SPAN><SPAN>[Month]</SPAN><SPAN>),</SPAN><SPAN>[Measure 22]</SPAN><SPAN>,</SPAN><SPAN>0.75</SPAN><SPAN><SPAN>)<BR /></SPAN></SPAN><img /> <P>&nbsp;</P> <SPAN>I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!<BR /><BR />My LinkedIn: <A href="https://www.linkedin.com/in/n%C3%A4ttiahov-00001/" target="_blank">https://www.linkedin.com/in/n%C3%A4ttiahov-00001/</A><BR /><BR /></SPAN></DIV> </DIV> Fri, 05 Apr 2024 12:29:10 GMT ValtteriN 2024-04-05T12:29:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-the-Percentile-of-a-Measure/m-p/3813511#M149143 <P>Hello,<BR />I am trying to find the Percentile (75%) of the below table for the colmun "Order Lines/Order".<BR />All the columns (except the month) are measures.</P><P><img /></P><P>I am familiar with the proper functions for the PRECENTILE but&nbsp; these require tables and not measures.&nbsp;<BR />Could you please advise?</P> Fri, 05 Apr 2024 12:18:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-the-Percentile-of-a-Measure/m-p/3813511#M149143 kleopatraath123 2024-04-05T12:18:29Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-the-Percentile-of-a-Measure/m-p/3813561#M149146 <P>Hi,<BR /><BR />You can use PERCENTILEX functions to get this:<BR /><BR /></P> <DIV> <DIV><SPAN>Measure</SPAN> <SPAN>23</SPAN><SPAN> =</SPAN> <SPAN>PERCENTILEX.INC</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>'Table (32)'</SPAN><SPAN>[Month]</SPAN><SPAN>),</SPAN><SPAN>[Measure 22]</SPAN><SPAN>,</SPAN><SPAN>0.75</SPAN><SPAN><SPAN>)<BR /></SPAN></SPAN><img /> <P>&nbsp;</P> <SPAN>I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!<BR /><BR />My LinkedIn: <A href="https://www.linkedin.com/in/n%C3%A4ttiahov-00001/" target="_blank">https://www.linkedin.com/in/n%C3%A4ttiahov-00001/</A><BR /><BR /></SPAN></DIV> </DIV> Fri, 05 Apr 2024 12:29:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Finding-the-Percentile-of-a-Measure/m-p/3813561#M149146 ValtteriN 2024-04-05T12:29:10Z