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.
Here I create a set of sample:
Sheet1:
Sheet2:
Then add a measure:
MEASURE =
VAR _Country =
SELECTEDVALUE ( Sheet2[Country] )
VAR _StudentName =
SELECTEDVALUE ( Sheet2[StudentName] )
VAR _PeerStudents =
CONCATENATEX (
FILTER (
ALLSELECTED ( Sheet2 ),
'Sheet2'[Country] = _Country
&& 'Sheet2'[StudentName] = _StudentName
),
'Sheet2'[PeerStudents]
)
RETURN
IF (
CONTAINSSTRING ( _PeerStudents, SELECTEDVALUE ( 'Sheet1'[StudentName] ) ),
SUM ( Sheet1[Scores] )
)
The result is as follow:
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.
Hi Anonymous , thanks for the reply. I used your method this is creating a small mismatch. So, in the second table (the table with the measure), The filter is not filtering the Subjects. As you can see the picture attached by you, you have selected English, yet It is showing scores for all the subjects. May you help me in fixing it?
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.