Filter Users that does not match both status

[Dark_Bi]

Hi, I am trying to filter users that are as "Status" only Concluded, but are not Active.

For example :

Paolo Pio was in a class Concluded but is also in a class Active so I should exclude it.

Carlo Tol Concluded two classes but is also Active in one class so I should exclude it.

Mich Rovati was in a class concluded so it is ok for the result table

Gianni Cosati is in a class Active so it should be excluded

Correct Results

Do you know how to do it in Power Bi?

Thank you very much.

[Dark_Bi]

Is it ok?

Table 1
User id	Name	Last name	Class ID
1	Paolo	Pio	2
1	Paolo	Pio	6
2	Mario	Meol	7
3	Carlo	Tol	5
3	Carlo	Tol	7
3	Carlo	Tol	8
4	Mich	Rovati	6
5	Gianni	Cosati	9

Table 2
Class ID	Status
2	Active
3	Concluded
4	Concluded
5	Active
6	Concluded
7	Concluded
8	Concluded
9	Active

[VahidDM]

Hi @Dark_Bi 

Can you send your data in TEXT format to be able to copy and paste them 

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[Dark_Bi]

Is it ok?

Table 1
User id	Name	Last name	Class ID
1	Paolo	Pio	2
1	Paolo	Pio	6
2	Mario	Meol	7
3	Carlo	Tol	5
3	Carlo	Tol	7
3	Carlo	Tol	8
4	Mich	Rovati	6
5	Gianni	Cosati	9

Table 2
Class ID	Status
2	Active
3	Concluded
4	Concluded
5	Active
6	Concluded
7	Concluded
8	Concluded
9	Active

[VahidDM · Accepted solution]

Hi @Dark_Bi 

Use this measure to filter your visuals:

Measure = 
Var _Status = filter(addcolumns(all('Table 1'),"ST",RELATED('Table 2'[Status])),[ST]="Active")
Var _A = SUMMARIZE(_Status,[Last name])
return
if(MAX('Table 1'[Last name]) in _A,1,0)

Output:

Download the attached file.

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

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[Dark_Bi]

Great Solution!! Thank you very much!