Column Filtering multiple values

[ChrisKent]

Hi,

I'm new to Power Bi and need some help for this one.

I want to be able to only show customers that have both Registerd and Not Registered serial numbers.

Customer C for example would not be shown as all their serial numbers are registered.

Not sure how to get that done with a measure or calculated column.

Any help would be greatly appreciated.

Cheers,

Chris 

[amitchandak · Accepted solution]

@ChrisKent ,

Create measures

M1  = calculate(distinctcount(Table[RegistionStatus]), allexcept(Table, Table[Customer]) )

Use this as visual level filter as check =2 

same can be created as a column too and used in filter

column=

calculate(distinctcount(Table[RegistionStatus]), filter(Table, Table[Customer]) = earlier( Table[Customer]) ) )

[ChrisKent]

Thanks amitchandak!

Worked perfectly.