topic Re: DAX Error: A function 'PLACEHOLDER" has been used in DAX Commands and Tips

DAX Error: A function 'PLACEHOLDER" has been used

Anonymous — Thu, 28 Oct 2021 17:25:03 GMT

I'm attempting to create a measure to divide one card by another.

Services Count / Services Goal = Percent to Goal

PTG Northstar =
DIVIDE(
CALCULATE(
COUNTROWS(CareerCenterGoals)
,CareerCenterGoals[Count of activityID -0 instead of blank]
)
,CALCULATE(
COUNTROWS('Goals: Career Center')
,'Goals: Career Center'[Services Goal]
)
)

I recieved this error: A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

Re: DAX Error: A function 'PLACEHOLDER" has been used

Greg_Deckler — Thu, 28 Oct 2021 17:39:14 GMT

Anonymous So generally that should look something like:

PTG Northstar = DIVIDE( CALCULATE( COUNTROWS(CareerCenterGoals) ,CareerCenterGoals[Count of activityID -0 instead of blank] = <some value> ) ,CALCULATE( COUNTROWS('Goals: Career Center') ,'Goals: Career Center'[Services Goal] = <some value> ) )

Re: DAX Error: A function 'PLACEHOLDER" has been used

Anonymous — Fri, 29 Oct 2021 06:19:57 GMT

Greg what should = <some value> be? Does it matter?

Re: DAX Error: A function 'PLACEHOLDER" has been used

v-yanjiang-msft — Thu, 04 Nov 2021 06:26:42 GMT

Hi Anonymous ,

According to your description, the highlight part of your DAX code bellow hasn’t express what outcome you want, it should be an expression but not a column.

If you want to calculate the count of rows which is not blank, you can use the following measure.

Here’s some information which may help you to understand.

https://docs.microsoft.com/en-us/dax/calculate-function-dax

https://www.sqlgene.com/2019/04/16/dax-error-a-function-xxxx-has-been-used-in-a-true-false-expression-that-is-used-as-a-table-filter-expression-this-is-not-allowed/

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: DAX Error: A function 'PLACEHOLDER" has been used

Anonymous — Thu, 04 Nov 2021 13:45:30 GMT

I have measure 1 which counts number of cells and returns "0" instead of blank.

I have measure 2 which is divisional goal.

I'm attempting to create measure 3 to show me percent of goal. The two measures divided by each other.

v-yanjiang-msft