Best practices for multiple fact tables and time frames

Hi elJukes 

So far, i can work out your requirement 1 and 2

1.create a new table without relationship with other tables

yeargroup = VALUES('group'[YearGroup])

2. create measures in the group memberships fact table

condition1 = IF(SELECTEDVALUE(yeargroup[YearGroup])=MAX('group'[YearGroup]),1,0)

condition2 = IF(SELECTEDVALUE(yeargroup[YearGroup])=MAX('group'[YearGroup])+1,1,0)

3.

Add [YearGroup] from the new created table "yeargroup" into a slicer,

Add [condition1] in the visual level filter of the table called "test results for that same year group/grade",

Add [condition2] in the visual level filter of the table called "test results for their previous year group/grade"

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.