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

[GB74]

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.

[BMally]

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]

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 · Accepted solution]

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

[Syndicate_Admin]

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

[InDranilRJ]

Really Worked

[GB74]

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.