Forum Discussion
Solved
ALLSELECTED Syntax with percentile
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)
SalmanABDul_97 , try like
%75= CALCULATE(PERCENTILEX.INC(VALUES(Product[Productname]),CALCULATE(fact[value]),0.75), allselected())
2 Replies
SalmanABDul_97 , try like
%75= CALCULATE(PERCENTILEX.INC(VALUES(Product[Productname]),CALCULATE(fact[value]),0.75), allselected())
Thanksm, it is working.
i also found this :
%75= PERCENTILEX.INC(ALLSELECTED(Product[Product name]),CALCULATE(fact[value]),0.75)
