Forum Discussion
DAX Error: A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table
Hi, I am new to DAX. I have an assignment which requires me to convert all 3 steps tables to only one table using CALCULATETABLE function. When i tried to do for the first 2 steps, there is an error ...
Data-Rainer
Advocate IV
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)
)
Worked for me too, thanks!