Forum Discussion
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. This is not allowed."
I tried every other way but it's still showing the same error msg
I'm want to calculate dependences in percentage:
Dependents in % = DIVIDE(CALCULATE(COUNT(churn[Dependents]), churn[Dependents]="Yes", Churn[Churn Rate]= "Yes"), CALCULATE(COUNT(churn[Dependents]), Churn[Churn Rate]="Yes"),0)
If anyone can help me with this, plz let me know
Thank you in advance.
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)
4 Replies
- mickey64
Super User
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)
