Filter a table with two slicers on the same field

[confidentnwrong]

Hi all,

I am trying to have a table that displays students who got a minimal grade in 2 subjects.

I want to have 2 slicers to choose the subjects, then 2 other slicers to choose the minimal grade, and a table displaying all the students who these conditions apply to. I'm having trouble filtering through the 2 subjects, I'll look into the grades later (but it forces me to use a slicer per subject)

So for instance, if I have no filter on, the table looks like :

name	subject	grade
a	maths	50
a	physics	70
b	maths	90
b	physics	80
c	maths	100
c	chemistry	40
c	poetry	50
d	maths	40
e	maths	30
e	physics	80
e	chemistry	70

Then if I put the first slicer on physics and the other one on maths, I'll have all the people who took maths AND physics and their grades in those subjects only, so :

name	subject	grade
a	maths	50
a	physics	70
b	maths	90
b	physics	80
e	maths	30
e	physics	80

So far all I've managed to do was making 2 tables, and filtering each by a filter. If I filter by both slicers at the same time, then I get nothing displayed because maths =/= physics.

This is what my model basically looks like:

Model

[amitchandak · Accepted solution]

@confidentnwrong , Refer if this can help

Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: https://youtu.be/exN4nTewgbc

[confidentnwrong]

I miswrote my parenthesis in the last message ! Thank you for the help.

Afterwards I got an issue where the grades displayed where only the ones of the table dim_class, even though the names displayed came from both dim_class and Class_new.

In case this helps anyone, I'm posting how I was able to solve this :

I ended up creating 2 tables based on the dim_class table, Class_new and Class_2 using

Class_new = 'dim_class'

Then I created measures to select the classes and the grades based on the names, one per new table

Selection = 
Var comp_1 = SELECTEDVALUE('Class_new'[Name_class])
Return CALCULATE(SUM('fact_results'[grade]), 'dim_class'[Name_class] = comp_1 )

And thus when displaying in a table, I choose the fields : 

'dim_student'[Name_student]

'measures'[Selection]

'class_new'[Name_class]

'measures'[Selection2]

'class_2'[Name_class]

Finally, by using slicers on 'class_new'[Name_class] and 'class_2'[Name_class], I can get my results 🙂

Remark : This solution displays all the grades of all the students taking either classes !

[confidentnwrong]

Thank you for the help

However I can not seem to adapt the measures to my problem. 

I followed along the video and made a Class_new table with the same info as the existing Class table, but when it comes to creating the measure Class_Name 2, I get the error "A 'FILTER' function was used in a True/False expression as a table filtre expression. This is unauthorized."

Here is how I wrote the measure :

Class_name 2 = CALCULATE([Name_class]
FILTER(ALL('dim_class'), 'dim_class'[ID_class]) in ALLSELECTED(Class_new[ID_Class])
)

And here's how I created the Class_new table :

Class_new = 'dim_class'

Do you know where I went wrong ?