Forum Discussion
M_23
3 years agoNew Member
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....
- 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
Super User
3 years agoHow 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)
- M_233 years agoNew Member
Yes it worked!!!
Thank you so much😊