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 ro...
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.

     

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.