Forum Discussion
Solved
Filter Users that does not match both status
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 exclu...
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!!
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 |