Forum Discussion

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

Problem with joining tables and filters

Hello, I have a job posting table and a location table, linked on Location ID.  I  have a couple measures, one on Job Posting table, total Postings, and one on the Location table, total Staffing, an...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    aashton well then make small tweak and you will be good to go:

    Total FTEStatus = SUM(JobRequisitions[FTEStatus]) +
IF ( ISFILTERED ( 'CRM Sharepoint'[New/Existing Column] ),
CALCULATE (sum(JobRequisitions[FTEStatus]), REMOVEFILTERS ('CRM Sharepoint'), KEEPFILTERS (JobRequisitions[Location_Identifier] = "NULL" ) )
, 0 
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

aashton so you want to keep the location identifier which is null regardless of what you filter on location table, correct?

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

    Thank you, but the FTEStatus per job does not always equal 1, it could be .5, .8.  So the total rows does not always equal the total FTEStatus.

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

    Yes correct