https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALLSELECTED-Syntax-with-percentile/m-p/2404266#M63068 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="364241" data-lia-user-login="SalmanABDul_97" class="lia-mention lia-mention-user">SalmanABDul_97</a> , try like </P> <P>&nbsp;</P> <P>%75= CALCULATE(PERCENTILEX.INC(VALUES(Product[Productname]),CALCULATE(fact[value]),0.75), allselected())</P> Sat, 19 Mar 2022 04:26:49 GMT amitchandak 2022-03-19T04:26:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALLSELECTED-Syntax-with-percentile/m-p/2403376#M63002 <P>Hi again <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P><P>&nbsp;</P><P>this syntax is working correct as i need but i want to use allselected function to apply it on the all Visable table</P><P>i colud not know the right place to put ALLSELECTED in this formula , always i get syntax error.&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>%75= </SPAN><SPAN>PERCENTILEX.INC</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Product[Productname]</SPAN><SPAN>),</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>fact</SPAN><SPAN>[value]</SPAN><SPAN>),</SPAN><SPAN>0.75</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Fri, 18 Mar 2022 13:24:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALLSELECTED-Syntax-with-percentile/m-p/2403376#M63002 SalmanABDul_97 2022-03-18T13:24:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALLSELECTED-Syntax-with-percentile/m-p/2404266#M63068 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="364241" data-lia-user-login="SalmanABDul_97" class="lia-mention lia-mention-user">SalmanABDul_97</a> , try like </P> <P>&nbsp;</P> <P>%75= CALCULATE(PERCENTILEX.INC(VALUES(Product[Productname]),CALCULATE(fact[value]),0.75), allselected())</P> Sat, 19 Mar 2022 04:26:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALLSELECTED-Syntax-with-percentile/m-p/2404266#M63068 amitchandak 2022-03-19T04:26:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALLSELECTED-Syntax-with-percentile/m-p/2404444#M63081 <P>Thanksm, it is working.&nbsp;</P><P>&nbsp;</P><P>i also found this :</P><P>&nbsp;</P><DIV><DIV><SPAN>%75= </SPAN><SPAN>PERCENTILEX.INC</SPAN><SPAN>(</SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>Product[Product name]</SPAN><SPAN>),</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>fact</SPAN><SPAN>[value]</SPAN><SPAN>),</SPAN><SPAN>0.75</SPAN><SPAN>)</SPAN></DIV></DIV> Sat, 19 Mar 2022 13:34:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ALLSELECTED-Syntax-with-percentile/m-p/2404444#M63081 SalmanABDul_97 2022-03-19T13:34:07Z