ALLSELECTED Syntax with percentile

[SalmanABDul_97]

Hi again 🙂 

this syntax is working correct as i need but i want to use allselected function to apply it on the all Visable table

i colud not know the right place to put ALLSELECTED in this formula , always i get syntax error. 

%75= PERCENTILEX.INC(VALUES(Product[Productname]),CALCULATE(fact[value]),0.75)

[amitchandak · Accepted solution]

@SalmanABDul_97 , try like

%75= CALCULATE(PERCENTILEX.INC(VALUES(Product[Productname]),CALCULATE(fact[value]),0.75), allselected())

[SalmanABDul_97]

Thanksm, it is working. 

i also found this :

%75= PERCENTILEX.INC(ALLSELECTED(Product[Product name]),CALCULATE(fact[value]),0.75)