group by total data not updated

[df123445]

I have a master table that shows which student registered for a course:

STUDENT ID	COURSE
1234	xyz
5678	xyz
1234	abc

beneath that I have a table with extra details about students,  connected with a 1:many   so when a course is selected only the relevant info about the registered students is shown (student_details). 

STUDENT ID	AGE	GRADE
1234	20	A
5678	22	B
9876	21	B

Now with my question: 

I have created a new table (grades)with agregate data about students grades:

grade	Total
A	60
B	80
C	120

grades= GROUPBY(student_details,student_details[grade],"Total",COUNTX(CURRENTGROUP(),student_details[STUDENT ID]))

I've connected my new table "grades" to "student_details" via the grade field. But when I click on a specific course the chart with "grades" data is not updated. 

I hope this make sense & thanks in advance for any help.

[Anonymous · Accepted solution]

Hi @df123445 

After testing, you need to change the "Cross filter direction" to both among the three tables.

then it can work.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.