Forum Discussion
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 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.
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!!
5 Replies
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
Super User
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
