Filtering a table based on slicer input

[PJOS_1]

Greetings all, I'm new to PBI so hopefully this is a comically easy question.

I have a small lookup table that has each of my properties' names listed along with the operating company that operates them. Each property name is unique and each has an associated management company in the same record. There are only a small number of management companies in the table so each management company might have 3 or 4 different properties they run. I have a slicer that updates my report based on the property name.  

What I would like to do is, upon selection of a property name in my slicer, I'd like to show a list in a matrix of all other properties that share the same managment company. My gut tells me this is super easy. I can do the math for the set of properties but I can't seem to produce a list of them.

I thought producing it with CALCULATETABLE would work but I've learned that they don't take slicer input. 

Here's my DAX that is wrong:

Operator Properties =

var operator = SELECTEDVALUE(Properties_General[Operator])

RETURN

CALCULATETABLE(Properties_General,Properties_General[Operator]=operator)

[v-yiruan-msft · Accepted solution]

Hi @PJOS_1 ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

Best Regards

[lbendlin]

This is called "Filtering up" - have a look at this similar post

Solved: Filtering most detailed level, but displaying valu... - Microsoft Power BI Community