Trying to create a single row table from a slicer selection.

[JasonJ1957]

I'm trying to create a single row table from a slicer's selected City,ST.  Where I have the "Richmond, VA" below, I would like to have the selected value from the slicer to create only the single row of needed data.  I manually put "Richmond, VA" in so that I could confirm the data would pull from the main table.  If anyone could let me know if this is possible or if I should take another route I would greatly appreciate the help.  Thank you

CitiesDummy =

   SELECTCOLUMNS(

        FILTER(

            Cities,

            Cities[CityState] = "Richmond, VA"

         ),

        "Warehouse",Cities[city_ascii],

        "Latitude", Cities[lat],

        "Longitude", Cities[lng],

        "City", Cities[city],

        "ST", Cities[state_id],

        "CityState", Cities[CityState]

    )

[cengizhanarslan]

A calculated table is evaluated only at model refresh time, not at report interaction time. Slicers don’t change calculated tables. So this can not be done by using a calculated table as you do. You simply need to use Report View pane for this and put those fields in a table visual to be used with required filters.

[danextian · Accepted solution]

Hi @JasonJ1957 

Calculated tables and calculated columns do not respond to slicer selections. If a function like SELECTEDVALUE is used, it will return blank because the table has no awareness of the current filter context. They are evaluated only during data refresh, when the DAX expression is changed, when referenced tables or columns are updated, or when a referenced measure is modified.

[MasonMA]

I'm a bit confused why this Calcualted table is required. Wouldn't it be just a filter context plus visuals or measures on your report that do the same thing? 

For example, if your slicer is using Cities[CityState], Then simply add a Table visual, add these columns on the table visual, 

Cities[city_ascii] (Warehouse)

Cities[lat]

Cities[lng]

Cities[city]

Cities[state_id]

Cities[CityState]

When one CityState is selected, the table will show exactly one row automatically.

[ThxAlot]

That's impossible up till to the current version (February 2026). Table view doesn't interact with slicers in Report view.