Graphing two counts onto same visual with multiple date columns

[katemke]

I have a table that contains data similar to what is below (has been created from two distinct tables already:

HP ID	RC ID	Contact Date	Contact ID	Consent Date
10	1	3/10/2021	1.1	3/1/2021
null	2	3/10/2021	2.1	null
null	2	3/11/2021	2.2	null
11	null	null	null	3/2/2021
12	3	3/3/2021	3.1	3/1/2021
12	3	3/3/2021	3.2	3/1/2021
13	4	3/5/2021	4.1	3/5/2021

i have also created a simple date table and created relationship (one active, one inactive) with the two date columns in the table above

I am trying to create a single visual that will chart the number of contacts (distinct count of Contact IDs) on a single date and the number of consent (distinct count of HP ID's) on a single date - either as two disinct lines, or a bar/line graph, with the shared access being the date, but am not sure how to go about creating the correct measures to do so. 

Any help would be greatly appreciated. Thanks so much!

[amitchandak · Accepted solution]

@katemke , If they are two tables - no column, with date table you can have two active join and you can work with count and sum measures from both tables

If they two dates from one table. One inactive relationship need to be activated using userelationship

And you need use common date from date table on slicer and axis

example

calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Table'2[CreateDate], 'Date'[Date]))

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...