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

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