filter to a measure

[FrankGrimm]

Hey together,

i have a table 

Destination:
Load * inline [
User,Office
Tom,New York
Frank,Dallas
Tom,Washington
James,Toronto
Frank,Paris
Tom,Tokio
Julia,Tokio
Julia,Paris
];

i can genertate very easy the diagram 

and the data-list of the diagram

i can sort for  "# of offices"

But i can´t set a filter to       "# of offices"

My idea is, to select all people who have 2 offices and use this filter for all worksheets.

Thanks a lot.

Frank

[vinieme12]

Change the expression as below 

=If(count(distinct Office)>1,count(distinct Office))

OR 

count({<User={"=count(Distinct Office)>1"}>}distinct Office)

https://community.qlik.com/t5/Qlik-Design-Blog/The-Expression-Search/ba-p/1463907