Forum Discussion
Multiple table unions and joins
Hi jbrown,
You can create a table with the DAX below:
Table = SUMMARIZE('Table1','Table1'[Organization Name],"Meeting Attendance",COUNT(Table2[Session]),"Survey Participation",COUNT('Table3'[Survey Participation]))
As you didn't provide any sample data, I created a pbix file with some dummy data. You can download it below to see if it meet your requirements.
Best Regards,
Qiuyun Yu
Community SupportHi jbrown,
You can create a table with the DAX below:
Table = SUMMARIZE('Table1','Table1'[Organization Name],"Meeting Attendance",COUNT(Table2[Session]),"Survey Participation",COUNT('Table3'[Survey Participation]))
As you didn't provide any sample data, I created a pbix file with some dummy data. You can download it below to see if it meet your requirements.
Best Regards,
Qiuyun Yu
This works.
I also need to solve for instances where records don't have "Meeting Attendance" or "Survey Participation"
For example: Table1 contains all organizations
Table2 (meeting attendance) only has records if the organization attended meeting
Table 3 (survey participation) only has records if organization took the survey.
- v-qiuyu-msft
Hi jbrown,
As this issue is different from the original one, please create a new thread and share sample data to clarify the requirement. So we can find the solution promptly.
Best Regards,
Qiuyun Yu