Forum Discussion
undefined
Here I add a Slicer 2, just as the following picture shows:
The Slicer 1 is to filter the Sheet2(It is designed to help you screen students in Sheet2, so that it can not affect the output table visual)
You can add a Slicer 2 with the field [Subject] from Sheet1, the result is as follow:
It is worth noting that the sample is very simple, there are a lot of details that you still need to optimize.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RandomUser7117 , Do not join these tables. Use all slicer on duplicate table of Table1
Plot this measure with columns of table1.
If required remove column consition from _peer var or make and(&&) as or (||)
Peer score =
Var _peer = SUMMARIZE(filter(Table2, Table2[StudentName] in values(Tabledup[StudentName] ) && Table2[Country] in values(Tabledup[Country] ) && Table2[Subject] in values(Tabledup[Subject] )), Table2[StudentName])
return
calculate(sum(Table1[Scores]), filter(Table1, Table1[StudentName] in _peer && Table1[Country] in values(Tabledup[Country] ) && Table1[Subject] in values(Tabledup[Subject] )) )