Totals by group

[aashton]

Hello,

I have multiple tables of job leads; referrals, events, job boards, etc, all contain email as the key, name, address, phone, etc.  These tables are linked to an Applications table on email, to see who applied for a job.  Each application is given a Candidate ID, which links to the contracts table once they are hired.  For each type of job lead, I have to find the total leads, applications and hired.  I'm unsure how to set-up this data?  Should all leads be unioned into one table?  And, with current set-up, when counting distinct emails for lead count and applications, this seems to work, but when I count distinct candidate IDs to get total hires, it's always gives me the total hired overall, not by lead  type, see example of what I am getting:

[v-jingzhang]

Hi @aashton 

Please check the relationships between tables. Currently the count of Candidate ID returns the total hires because the "Lead Type" column cannot filter the "Candidate ID" column successfully. This is usually due to an incorrect cross-filter direction between two tables or there is no valid relationship between two tables. To make this filter work, the cross-filter direction of the relationship between the table where "Lead Type" is and the Applications table should be both, or single ("Lead Type" table filters Applications table). Create and manage relationships in Power BI Desktop

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.