Forum Discussion

aashton's avatar
aashton
Icon for Helper V rankHelper V
3 years ago
Solved

Dreaded Placeholder error

Hello, I have two tables, CRM Sharepoint ( a list of facilities) and Monthly Data, joined on the Facility ID.  I have a measure in Monthly Data: Current Vacancy = IF([WD Total FTE Model]=0,0,CALCUL...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi aashton 

    CALCULATE filters are tables. It is trying to identify which table is supposed to be filtered based on the provided measure value but your code identifies none. You need to manually tell the engine which table do you mean to filter. However, using CALCULATE in this case is not recommended. You may try

    COUNTROWS ( 

    FILTER (

    VALUES ( 'CRM Sharepoint'[CRM_Account_Name] ),

    [Current Vacancy] = 1

    )

    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi aashton 

CALCULATE filters are tables. It is trying to identify which table is supposed to be filtered based on the provided measure value but your code identifies none. You need to manually tell the engine which table do you mean to filter. However, using CALCULATE in this case is not recommended. You may try

COUNTROWS ( 

FILTER (

VALUES ( 'CRM Sharepoint'[CRM_Account_Name] ),

[Current Vacancy] = 1

)

)

  • aashton's avatar
    aashton
    Icon for Helper V rankHelper V
    3 years ago

    Thank you so much!!!