Hello Team,
I am struggling with the relationship mapping. Need your support please.
I am unable to use some dax formulas as i believe there is some relationship issue.
Total Hired Saudis in Saudi Arabia =
CALCULATE(
COUNTROWS('Max Status MaxDate AppID'),
'Job Application Details'[Nationality] = "Saudi" &&
'Job Requistion Details'[PwC Location] = "Saudi Arabia" &&
'Max Status MaxDate AppID'[Max Status] = "Hired"
)
I have 4 sheets in exel, Table 1 ""Max Status MaxDate AppID" which has 3 columns applicationid,MaxDate & MaxStatus
Table 2: Columns in the table "Job Application Details" are as follows, applicationid, gender, jobReqid, Nationality, SAVILLE Assessment, Current Employer
Table 3: "Job Requisition Details" has the following columns, jobReqId, Grade, PwC Location, Business Unit & Employee Type.
Table 4: Targets by Business Unit has 2 columns Business Unit & Target Offer Accepted
Table Max Status MaxDate AppID is linked to Job Application Details on many to one & cross function direction as single using the columns or unique id "applicationid". Then table job application details is linked to job requisition details using the column or unique id "jobreqid" using many to one & cross function direction as single. Then table job requisition details table is linked to table target by business unit using the unique column "Business unit (text format)" on many to one & cross fucntion as single.
I beleive i am doing something wrong. How can i attach the dataset & pbix file here. Need some urgent support please.
Thanks,.
