Forum Discussion

Sri57's avatar
Sri57
Frequent Visitor
2 years ago
Solved

A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp

Hi, I'm a newish user to PowerBI and struggling with a calculation. I'm getting the error "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp" when...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Sri57 

     

    This is due to the reference to Measure in the filter parameter of the CALCULATE function. The following documentation lists the cases in which this error occurs, so perhaps it can help you.

    Solving errors in CALCULATE filter arguments - SQLBI

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Is 

[BOD_LTP or TP_Measure]

an actual measure?

  • Sri57's avatar
    Sri57
    Frequent Visitor
    2 years ago

    yes lbendlin 

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Please provide more details. What's its definition?

      • Sri57's avatar
        Sri57
        Frequent Visitor
        2 years ago

        lbendlin BOD_LTP or TP_Measure =
        var a = MAX('Delivery'[Pallet per BOD])
        return
        IF (
        ISBLANK (a),
        BLANK (),
        IF (
        a < 16,
        "LTP",
        "TP"
        )
        )
        [Pallet per BOD] is again a calculated column

Related content