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 sales table with two date columns: an initial contact date and a booking date. I related both these date columns to a date table with the booking date as the active relationship. Using the date table relationship, I am able to get monthly counts of initial contact and bookings. Since the booking date is the active relationship, I can click on a month and get the list of bookings in a detail table.
Now I want another detail table with the list of initial contacts in that month. So this detail table needs to use the inactive relationship between the initial contact date and the date table, to get the rows that have initial contact dates that fall within the selected month. How do I do this?
@ashwinje, create the measures below:
Count - Contact Date =
CALCULATE (
COUNT ( Sales[Customer] ),
USERELATIONSHIP ( 'Date'[Date], Sales[Contact Date] )
)
Count - Booking Date = COUNT ( Sales[Customer] )
Result:
Proud to be a Super User!
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |