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,CALCULATE(1-DIVIDE(SUM('Monthly Data'[FTE Status]), [WD Total FTE Model]))). 

 
I'd like to find the total number of facilities with 100% Current Vacancy for a card.  I've been trying:
Sites 100% Vacant = CALCULATE(DISTINCTCOUNT('CRM Sharepoint'[CRM_Account_Name]), 'NAPA CR HCM Monthly Data'[Current Vacancy]=1)
And get the placeholder error...I never know what that means??
 
  • 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

    )

    )

2 Replies

  • 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

    )

    )