Forum Discussion

GB74's avatar
GB74
Frequent Visitor
4 years ago
Solved

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.
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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

    • GB74's avatar
      GB74
      Frequent Visitor
      4 years ago

      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.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      3 years ago

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

  • Manoelsa's avatar
    Manoelsa
    New Member
    3 years ago

    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
  • BMally's avatar
    BMally
    New Member
    2 years ago
    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."
Related content