Attempting to create stacked bar chart using 2 different tables

[afaherty]

Hello,

I am attempting to create a stacked bar chart using data from 2 different tables.  Here is a snippet/ example:

Here is the desired result:

There is a relationship between the two tables on Student ID.

Thank you!

[amitchandak · Accepted solution]

@afaherty , Assume Table 2 to Table 1 is 1-M relation

You can have meausre like

Graduated = countrows(Table1)

Certificate= calculate(countrows(Table1) , filter(Table2, Table2[Certificate]="Yes"))

Use these two measures on visual