Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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]))
@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]))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
99 | |
73 | |
65 |