Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
GB74
Regular Visitor

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

Hi,

I'm a newish user to PowerBI and struggling with a calculation.

I'm effectively trying to do a SUMIF, but I know you can't do that within PowerBI.

I want to show the sum of the value of all open orders that have a due date this month.

I've created a couple of extra columns to extract the month from the due date and another one to store the current month.

I've tried doing it with a number of different formulas, but all fail for various reasons.

I thought I had it right with:

 

Open Order Value due this month = Calculate(Sum('Sales Orders'[Value]),'Sales Orders'[Delivery Month]='Sales Orders'[Current Month])

 
but getting "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."
Any assistance would be greatly appreciated.
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@GB74 , Formula like. Try formula like

Open Order Value due this month = Calculate(Sum('Sales Orders'[Value]),filter('Sales Orders','Sales Orders'[Delivery Month]='Sales Orders'[Current Month]))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

6 REPLIES 6
BMally
New Member

I am having an error
Optimum_PGR_Option1 = CALCULATE(MAXX(ALL('Option 1'),[PGR]),[IR_Option1]=MAX([IR_Option1]))
but getting "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not
allowed."
Manoelsa
New Member

Boa tarde, estou tentando usar a medida abaixo para me retornar a media de lançamentos nos últimos 3 meses.

 

_mMEDIA PRESTACAO =
VAR MaxData =
    EOMONTH( MAX(fCT2[Data Lcto] ), 0)
VAR Meses3Atras =
    EOMONTH( MaxData, -3) +1
VAR Media =
    CALCULATE (
        [_mVALOR REAL],
        fCT2[_mVALOR REAL]< 0,
        fCT2[Data Lcto] >= Meses3Atras,
        fCT2[Data Lcto] <=MaxData
    ) / 3
RETURN
    Media
amitchandak
Super User
Super User

@GB74 , Formula like. Try formula like

Open Order Value due this month = Calculate(Sum('Sales Orders'[Value]),filter('Sales Orders','Sales Orders'[Delivery Month]='Sales Orders'[Current Month]))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Hola Community!!!

I am a begginer in the powerBi and I did not know how to solve this problem with the issue of calculating working days between two dates because I see "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression, which is not allowed."

I attach my code to help me.

thanks!!

RevisedDate vs ClearDate =
CALCULATE(
COUNTROWS('Auto Calendar') ,
DATESBETWEEN('AutoCalendar'[Date], IoBl[RevisedDate], IoBl[ClearDate]),
'Auto-calendar'[working days]= TRUE(),
ALL(IoBl)
)

Really Worked

Thank you so much.

The formula works correctly. The value displayed doesn't look correct, but I can go from there to see what is going wrong.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.