Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,.
Hi @ashraf_mohammed ,
Can you please share some dummy data that keep the raw data structure instead of screenshots? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Notice: single direction mode relationship filter effects only work on one side.
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |