Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to Solution.
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)
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)
Yes it worked!!!
Thank you so much😊
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)
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |