Forum Discussion
Many to Many Join
I have two datasets I want to join so I can use a slicer/filter to show the total number of incidents based compared to the total number of hours on a job. Hours Dataset Job Name Date Total...
Hi,
Create a Job Name table and build a relationship from the Job Name table of both tables to the new Job name table created. Build your slicer from the new job names table and select A1234 there. Write these measures:
Hours = sum(Hours[hours])
Count = countrows(Incidents)
Hope this helps.
I ended up creating a Date Table and then joining both the tables based on dates to those and it worked before I saw this.