Hi,
The following measure within Power BI which returns the error:
A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
M.New.EnglishTarget = IF(ISBLANK(CALCULATE(COUNT('dt_ReadingSummary'[Candidate_Number]), 'dt_ReadingSummary'[English Target Hit]=1 && 'dt_ReadingSummary'[CompletedBooks]>0)/COUNT('dt_ReadingSummary'[Candidate_Number])),0,(CALCULATE(COUNT('dt_ReadingSummary'[Candidate_Number]), 'dt_ReadingSummary'[English Target Hit]=1 && 'dt_ReadingSummary'[CompletedBooks]>0)/COUNT('dt_ReadingSummary'[Candidate_Number])))
As similar question came up not too long ago where a filter expressions were used inside a CALCULATE function, without explicitly using the FILTER function. It worked very well in my Excel version with Power Pivot as well as in my Power BI desktop app.
The attached file contain a simplified example with two measures. One without FILTER and one with. Both give the same result for me. See if the second one works on your end.
