Forum Discussion
DAX Error: A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table
Advocate II don't know if this issue was solved or not, but just to keep in mind for these kind of situations, we can not use both measures to check the boolean condition in the filter argument.
The following article explains the issue in detail.
https://p3adaptive.com/2012/06/filter-when-why-how-to-use-it/
If this helps 🙂
Advocate IVThanks "mgb-nav-pbi", your linked article has solved my issue,
whereby I got the same error, when uing a measure in a CALCULATE expression as a filter,
e.g. measure < 155.
Just putting the FILTER function in front of the measure has solved my issue,
e.g. FILTER(measure < 155)
Rooms < $155 = CALCULATE(
SUM('Invoice'[Room Count]),
'Invoice Line'[Item Group]="HOTEL",
FILTER ([measure] < 155)
)
SDittmannFleetFILTER() works. Thanks!
This worked for me inside a calculate statment, anyone know the logic as to why this works? what is filter doing behind the scenes?
This is great, I was stuck with this issue for some days and this solution (FILTER) actually worked.
Thanks!
Worked for me too, thanks!
