Forum

More many-to-many r...
 
Notifications
Clear all

More many-to-many relationship issues

2 Posts
2 Users
0 Reactions
64 Views
(@pawintx)
Posts: 5
Active Member
Topic starter
 

Hi Mynda - thanks for the awesome courses!  It has really helped expand my skillset!

I've reviewed the other post concerning relationships and session 6 materials but I'm still stuck and having difficulties with trying to get the correct count results based on two fact tables.  The main fact table has most of the transaction data by who (team members), what, and when. The second fact table supports the reality that each team member can belong to multiple work teams. I need to report the count of various tasks completed by an individual for a given date (or selection of dates). And I need to report the average of the various tasks for the team (or teams) that the individual belongs to. 

You mention in the course that many-to-many relationships can be mimicked with DAX - can you please show me how I might do that here? Details are in the attached word doc.

Thank you in advance for your help,

Paul

 
Posted : 03/09/2016 4:09 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Paul,

Can you please share a sample workbook so we can help you further. If you prefer to share your actual workbook offline then you can email it to me direct:  website@

Thanks,

Mynda

 
Posted : 05/09/2016 9:52 pm
Share: