Forum Discussion
Graphing two counts onto same visual with multiple date columns
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!
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]))
1 Reply
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]))