https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Quartile/m-p/3477082#M132842 <P>Power BI has built in DAX functions for this - PERCENTILEX etc.</P> <P>&nbsp;</P> Sat, 14 Oct 2023 23:41:55 GMT lbendlin 2023-10-14T23:41:55Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Quartile/m-p/3449061#M131324 <P>Hello,</P><P>I am struggling to group customers into "Tiers" based on growth potential. The snapshot shows the expected result.</P><P>One important thing to note is that <STRONG>measure</STRONG> growth potential (column B) is not located in the same table as customer (column A), it is made of variables from multiple tables and sits in a "measure table". I think that's where I am struggling, i.e., I am not able to create a virtual table like the one in columns A-C and perform the percentiles.</P><P>Needless to say, growth potential is dynamic according to filters.&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Many thanks for your help.</P> Wed, 27 Sep 2023 06:28:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Quartile/m-p/3449061#M131324 Anonymous 2023-09-27T06:28:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Quartile/m-p/3477082#M132842 <P>Power BI has built in DAX functions for this - PERCENTILEX etc.</P> <P>&nbsp;</P> Sat, 14 Oct 2023 23:41:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Quartile/m-p/3477082#M132842 lbendlin 2023-10-14T23:41:55Z