Forum Discussion

M_23's avatar
M_23
New Member
3 years ago
Solved

Dax Function in powerbi

Hi all I'm new to Powerbi, I'm trying to create new measure but it it showing me error  "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression....
data protection
  • mickey64's avatar
    mickey64
    3 years ago

    How about formula below?

     

    Dependents in % = DIVIDE(COUNTX(FILTER(churn, churn[Dependents]="Yes" && Churn[Churn Rate]= "Yes"), churn[Dependents]), COUNTX(FILTER(churn, Churn[Churn Rate]="Yes"), churn[Dependents]),0)

     

mickey64's avatar
mickey64
Icon for Super User rankSuper User
3 years ago

For your reference.

 

Dependents in % = DIVIDE(CALCULATE(COUNT(churn[Dependents]), churn[Dependents]="Yes" && Churn[Churn Rate]= "Yes"), CALCULATE(COUNT(churn[Dependents]), Churn[Churn Rate]="Yes"),0)