Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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
 
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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])) )

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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])) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you. Great help. 🙂

  • Jennilyn's avatar
    Jennilyn
    Regular Visitor
    2 years ago

    Same error. How do I fix this?

    State Change Count =
    CALCULATE (
        COUNTROWS ( 'States' ),
        ALLEXCEPT ( 'States', 'States'[Work Item Id] ),
        'States'[Date] <= EARLIER ( 'States'[Date] ),
        'States'[State Changed]
    ) + 0
Related content