topic Re: Attempting to create stacked bar chart using 2 different tables in DAX Commands and Tips

Attempting to create stacked bar chart using 2 different tables

afaherty — Thu, 22 Dec 2022 17:43:04 GMT

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 — Fri, 23 Dec 2022 04:23:49 GMT

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