A function 'PLACEHOLDER' has been used in a True/False expression error in aging calculation

Question

I am wanting to create aging bands for Inventory - for example stock shelf life 0-1 months, 1-6 months, 7-12 months 13+, but when i try the dax measure , i get the error A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

Can someone help with this please and explain why this is happening?

Thank you!

PBIX here SLOB.pbix which included desired result

dangar332 · Answer

Hi, watje255_ju&nbsp;&nbsp;In your measure threr are multiple conditions in filter expression use it in filter () function&nbsp;&nbsp;LikeFilter (tablename, condition 1&amp; condition 2)&nbsp;Refer&nbsp;Here&nbsp;for similar solutions&nbsp;

watje255_ju · Answer

Thanks for your reply! I am not filtering the table, but a measure,&nbsp;Stock On Hand with Shelf Life &gt; 1 Month =CALCULATE(&nbsp; &nbsp; [Stock On Hand], &nbsp; &nbsp; [Shelf Life Remaining] &gt; 1) or&nbsp;Stock On Hand with Shelf Life 1-6 Months =CALCULATE(&nbsp; &nbsp; [Stock On Hand], &nbsp; &nbsp; [Shelf Life Remaining] &gt;= 1 &amp;&amp; [Shelf Life Remaining] &lt;= 6)&nbsp;Would you mind showing the correct Dax formula in the PBIX (link above) Thanks again!

dangar332 · Answer

Hi, watje255_ju&nbsp;&nbsp;Try belowMonth =CALCULATE(&nbsp; &nbsp; [Stock On Hand],&nbsp; &nbsp; [Shelf Life Remaining] &gt; 1) or&nbsp;Stock On Hand with Shelf Life 1-6 Months =CALCULATE(&nbsp; &nbsp; [Stock On Hand],&nbsp; &nbsp; Filter (tablename,[Shelf Life Remaining] &gt;= 1 &amp;&amp; [Shelf Life Remaining] &lt;= 6))

watje255_ju · Answer

Thanks again still not working properly, can you access the PBIX File?

For the first example i get the same error as noted in the original post, and the second formula doesn't return the expect values for the buckets when altering the formula for 13+ months for example, thanks again for your help

dangar332 · Answer

Hi, watje255_ju&nbsp;&nbsp;Month =&nbsp;CALCULATE(&nbsp;&nbsp; &nbsp; [Stock On Hand],&nbsp;&nbsp; Filter (table name,&nbsp; [Shelf Life Remaining] &gt; 1)&nbsp;) or&nbsp;&nbsp;Stock On Hand with Shelf Life 1-6 Months =&nbsp;CALCULATE(&nbsp;&nbsp; &nbsp; [Stock On Hand],&nbsp;&nbsp; &nbsp; Filter (tablename,[Shelf Life Remaining] &gt;= 1 &amp;&amp; [Shelf Life Remaining] &lt;= 6)&nbsp;)

Forum Discussion

A function 'PLACEHOLDER' has been used in a True/False expression error in aging calculation

7 Replies

Related content

True/False, if statement

DAX Involving TRUE/FALSE Column

True/False Measure

True False Statement Help

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