Forum Discussion
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...
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]))
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."