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!!
VahidDM
Super User
Super UserIs 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
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!!
Great Solution!! Thank you very much!
