Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX Error: A function 'PLACEHOLDER" has been used

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) ,CareerCen...
DAX Commands and Tips
Help Requested
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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