Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |