topic Re: A function 'PLACEHOLDER' has been used in a True/False expression error in aging calculation in DAX Commands and Tips

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

watje255_ju — Wed, 06 Dec 2023 03:14:10 GMT

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

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

Dangar332 — Wed, 06 Dec 2023 05:54:05 GMT

Hi, watje255_ju

In your measure threr are multiple conditions in filter expression use it in filter () function

Filter (tablename, condition 1& condition 2)

Refer Here for similar solutions

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

watje255_ju — Wed, 06 Dec 2023 05:54:12 GMT

Thanks for your reply! I am not filtering the table, but a measure,

Stock On Hand with Shelf Life > 1 Month =

CALCULATE(

[Stock On Hand],

[Shelf Life Remaining] > 1

) or

Stock On Hand with Shelf Life 1-6 Months =

CALCULATE(

[Stock On Hand],

[Shelf Life Remaining] >= 1 && [Shelf Life Remaining] <= 6

)

Would you mind showing the correct Dax formula in the PBIX (link above) Thanks again!

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

Dangar332 — Wed, 06 Dec 2023 05:58:44 GMT

Hi, watje255_ju

Try below

Month =

CALCULATE(

[Stock On Hand],

[Shelf Life Remaining] > 1

) or

Stock On Hand with Shelf Life 1-6 Months =

CALCULATE(

[Stock On Hand],

Filter (tablename,[Shelf Life Remaining] >= 1 && [Shelf Life Remaining] <= 6)

)

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

watje255_ju — Wed, 06 Dec 2023 06:09:22 GMT

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

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

Dangar332 — Wed, 06 Dec 2023 07:37:55 GMT

Hi, watje255_ju

Month =

CALCULATE(

[Stock On Hand],

Filter (table name, [Shelf Life Remaining] > 1)

) or

Stock On Hand with Shelf Life 1-6 Months =

CALCULATE(

[Stock On Hand],

Filter (tablename,[Shelf Life Remaining] >= 1 && [Shelf Life Remaining] <= 6)

)

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

watje255_ju — Sun, 10 Dec 2023 21:59:28 GMT

Hi, thanks for your reply, the formula isn't working as expected, I should only be getting 39,198 , not 39,809, do you know why? Thanks!!

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

watje255_ju — Sun, 10 Dec 2023 22:01:53 GMT

And the same logic for 7-12 months returns the above values when I am after 309

Thanks again 🙂