Forum Discussion

SalmanABDul_97's avatar
SalmanABDul_97
Icon for Helper I rankHelper I
4 years ago
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 form...
DAX
DAX ALLSELECTED
  • amitchandak's avatar
    amitchandak
    4 years ago

    SalmanABDul_97 , try like

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

SalmanABDul_97 , try like

 

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

SalmanABDul_97's avatar
SalmanABDul_97
Icon for Helper I rankHelper I
4 years ago

Thanksm, it is working. 

 

i also found this :

 

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