How to apply slicer or page filters to a virtual table?

[mastone]

I wanted to define a virtual table that would respond to Slicers and Page filters but can't seem to do it.   I have a large complex set of queries that I want to use to generate a virtual table, but I need those queries to respond to slicers and page filters.  I've simplified everything down to it's simplest form and still can't get the virtual table (or more specifically the visualization based on the virtual table) to get filtered.

I have a tabled called "Facilities" that looks like:    

Id	Name
1	Facility A
2	Facility B
3	Facility C

I have a Virtual Table defined simply as this:

Test =
    VAR facs = ALLSELECTED(Facilities)
RETURN
    facs

I then take one of the columns and drag it into a Table visualization.  I end up with the facilities table above.   All is well.

However, if I then set a Page Filter or add a slicer where I filter Facilities[Id]=2, I would expect to just see 

Id	Name
2	Facility B

But I don't, I see the full facilities table.

How can I create a virtual table that will respond to page and slicer filters??

[Greg_Deckler]

@mastone Calculated tables do not work that way. They are static and do not respond to things selected in the desktop. Real virtual tables are contained with Measures as a VAR. Would need more information on why you are trying to do what you are trying to do.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

Hi @mastone 

Your virtual table should be a calculated table, and if you want to apply a slicer to it, you can create a measure.

e.g 

Measure = CALCULATE(MAX(Test[Name]),FILTER(Test,[Id] in VALUES(Facilities[Id])))

Then put the measure and 'id' column of the test table to the table visual

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.