cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
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]))

6 REPLIES 6
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."
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
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]))

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)
)

New Member

Really Worked

Regular Visitor

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors