Forum Discussion
Trying to create a single row table from a slicer selection.
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.
Super UserI'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.