Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to fix this error -A function 'PLACEHOLDER' has been used in a True/False expression that is use

Hello:
 
 In progress Past Due = CALCULATE(COUNT('Table_query__1'[ ID]),Table_query__1[Overall Status]in{"Completed","In-Progress"}||Table_query__1[Overall Status]=BLANK(),Table_query__1[Review Scheduled Completion Date]<=TODAY(),Table_query__1[Review Actual Complete Count]=BLANK())
 
I am getting this error: A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
How may I solve it?
Thanks
 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , try like

 

In progress Past Due = CALCULATE(COUNT('Table_query__1'[ ID]),Table_query__1[Overall Status] in {"Completed","In-Progress"}
|| isblank(Table_query__1[Overall Status])
,Table_query__1[Review Scheduled Completion Date]<=TODAY()
,isblank(Table_query__1[Review Actual Complete Count]))

 

or

 
In progress Past Due = CALCULATE(COUNT('Table_query__1'[ ID]),Filter(Table_query__1 (Table_query__1[Overall Status] in {"Completed","In-Progress"}
|| isblank(Table_query__1[Overall Status]) ) && Table_query__1[Review Scheduled Completion Date]<=TODAY()
&& isblank(Table_query__1[Review Actual Complete Count])) )

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thank you. Great help. 🙂

amitchandak
Super User
Super User

@Anonymous , try like

 

In progress Past Due = CALCULATE(COUNT('Table_query__1'[ ID]),Table_query__1[Overall Status] in {"Completed","In-Progress"}
|| isblank(Table_query__1[Overall Status])
,Table_query__1[Review Scheduled Completion Date]<=TODAY()
,isblank(Table_query__1[Review Actual Complete Count]))

 

or

 
In progress Past Due = CALCULATE(COUNT('Table_query__1'[ ID]),Filter(Table_query__1 (Table_query__1[Overall Status] in {"Completed","In-Progress"}
|| isblank(Table_query__1[Overall Status]) ) && Table_query__1[Review Scheduled Completion Date]<=TODAY()
&& isblank(Table_query__1[Review Actual Complete Count])) )

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.