Skip to main content
cancel
Showing results for 
Search instead 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

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
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors