Filter by two different types

[msflaviah]

Hi there, I have this data here 

Location Type
ABB008 STS
ABB008 DOI
ABB009 FI
ABB025 FI
ABB035 DOI
ABB135 FI
ABB270 RED
ABB270 STS

I need to come up with a way to show the locations that have STS and at least another type associated. Like ABB270 has STS and RED. 

thank you so much!! 

[Ahmedx]

plse try this corrected code

Flag =

VAR _t1 = COUNTROWS(FILTER('Table','Table'[Type]="STS"))

VAR _t2= COUNTROWS(FILTER('Table','Table'[Type]<>"STS"))

RETURN

IF(_t1>=1&& _t2>=1,1)

[jdbuchanan71 · Accepted solution]

@msflaviah 

You can write a measure like this:

Filter = 
VAR _sts = CALCULATETABLE ( VALUES ( YourTable[Location] ), YourTable[Type] = "STS" )
VAR _other = CALCULATETABLE ( VALUES ( YourTable[Location] ), YourTable[Type] <> "STS" )
VAR _list = INTERSECT ( _sts, _other )
RETURN
CALCULATE ( COUNTROWS ( YourTable ), _list )

Then use that as a filter on the visual to return only the Location that have STS + other.