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

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.

  • InDranilRJ's avatar
    InDranilRJ
    New Member
    4 years ago

    Really Worked

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