Forum Discussion

JasonJ1957's avatar
JasonJ1957
Regular Visitor
7 months ago
Solved

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

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]
    )
Need Help
  • danextian's avatar
    danextian
    7 months ago

    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.

     

4 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    7 months ago

    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.

     

  • cengizhanarslan's avatar
    cengizhanarslan
    Icon for Super User rankSuper User
    7 months ago

    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.

  • ThxAlot's avatar
    ThxAlot
    Icon for Super User rankSuper User
    7 months ago

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

  • MasonMA's avatar
    MasonMA
    Icon for Super User rankSuper User
    7 months ago

    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.