topic PERCENTILEX.EXC help in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/PERCENTILEX-EXC-help/m-p/405028#M156527 <P>hi, trying to get the 40% percentile from the column i created in the summarize table,</P><P>however it says the expression specified in the query is not a valid table expression</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>PERCENTILEX.<SPAN>EXC</SPAN> (<BR />&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>SUMMARIZE</SPAN> (<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>FILTER</SPAN> (<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Panel,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>Panel[PermanentConsumer]</SPAN> = <SPAN>"1"</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&amp;&amp;</SPAN> <SPAN>Panel[ValidConsumer]</SPAN> = <SPAN>1</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&amp;&amp;</SPAN> <SPAN>Panel[Stores]</SPAN> = <SPAN>1</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>Panel[Member_ID]</SPAN>,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>"Qsales"</SPAN>, <SPAN>SUM</SPAN> ( <SPAN>Panel[SelectedQty]</SPAN> )<BR />&nbsp;&nbsp;&nbsp;&nbsp;),<BR />&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>[qsales]</SPAN>,<BR />&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>0.4</SPAN><BR />)</P> Thu, 26 Apr 2018 10:40:49 GMT liran 2018-04-26T10:40:49Z PERCENTILEX.EXC help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/PERCENTILEX-EXC-help/m-p/405028#M156527 <P>hi, trying to get the 40% percentile from the column i created in the summarize table,</P><P>however it says the expression specified in the query is not a valid table expression</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>PERCENTILEX.<SPAN>EXC</SPAN> (<BR />&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>SUMMARIZE</SPAN> (<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>FILTER</SPAN> (<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Panel,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>Panel[PermanentConsumer]</SPAN> = <SPAN>"1"</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&amp;&amp;</SPAN> <SPAN>Panel[ValidConsumer]</SPAN> = <SPAN>1</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>&amp;&amp;</SPAN> <SPAN>Panel[Stores]</SPAN> = <SPAN>1</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>Panel[Member_ID]</SPAN>,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>"Qsales"</SPAN>, <SPAN>SUM</SPAN> ( <SPAN>Panel[SelectedQty]</SPAN> )<BR />&nbsp;&nbsp;&nbsp;&nbsp;),<BR />&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>[qsales]</SPAN>,<BR />&nbsp;&nbsp;&nbsp;&nbsp;<SPAN>0.4</SPAN><BR />)</P> Thu, 26 Apr 2018 10:40:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/PERCENTILEX-EXC-help/m-p/405028#M156527 liran 2018-04-26T10:40:49Z