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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
GB74
New Member

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

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

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.