Forum Discussion

JasonJ1957's avatar
JasonJ1957
Regular Visitor
6 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
    6 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.

     

danextian's avatar
danextian
Icon for Super User rankSuper User
6 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.