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.
Hi,
I can't seem to wrap my head around how to calculate this using DAX. I hope one of you clever people would be able to help me.
I have a table of sales reps:
SalesRepName | MeetingOwner
I have a table of meetings:
MeetingID | MeetingOwner | Date
and a second table of meetings:
MeetingID | MeetingAttendeeCol1 | MeetingAttendeeCol2 | Date
I need a graph displaying how many meetings a given sales rep has attended either as an owner or as an attendee. All meetings have at least one person linked (the owner), but may have multiple that need to be counted, e.g. if a given meeting has both an owner and two attendees.
-----
One idea I've had is to unpivot the meetings table on the sales rep value leading to, instead of having one row pr unique meeting, instead having one row per unique meeting-sales rep and then counting sales reps from that table. But I was hoping for a prettier solution with less redundant data.
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 |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
172 | |
108 | |
105 | |
71 | |
70 |