topic Re: A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp in DAX Commands and Tips

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

Sri57 — Tue, 20 Feb 2024 14:14:45 GMT

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 I try to create a measure like below:
% LTP BOD_Test =
IF (
CALCULATE (
DISTINCTCOUNT ( 'Delivery'[BOD] ),
'Delivery'[BOD_LTP or TP_Measure] = "LTP"
)
= BLANK (),
0,
DIVIDE (
CALCULATE (
DISTINCTCOUNT ( 'Delivery'[BOD] ),
'Delivery'[BOD_LTP or TP_Measure] = "LTP"
),
CALCULATE (
DISTINCTCOUNT ( 'Delivery'[BOD] ),
FILTER (
'Delivery',
'Delivery'[BOD_LTP or TP_Measure] <> BLANK ()
)
)
)
)

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

lbendlin — Tue, 20 Feb 2024 23:07:11 GMT

[BOD_LTP or TP_Measure]

an actual measure?

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

Sri57 — Wed, 21 Feb 2024 00:12:19 GMT

yes lbendlin

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

lbendlin — Wed, 21 Feb 2024 00:18:38 GMT

Please provide more details. What's its definition?

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

Sri57 — Wed, 21 Feb 2024 00:31:59 GMT

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

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

Anonymous — Wed, 21 Feb 2024 04:36:55 GMT

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.