Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

What if Parameter not refreshing

Hi All,    I have 2 tables containing years' data.  I want to create a slicer that would filter the 2 tables at once.  I created a "what if Parameter" with a default value. And a condition (a sim...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, Anonymous 

     

    The value of the calculated column won't change as the slicer changes.

    You can create a measure instead of column.

    Like this:

     

    Measure = IF(SELECTEDVALUE('Table'[year])=SELECTEDVALUE(Parameter[Parameter]),1,0)

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.


    Best Regards,
    Community Support Team _ Janey

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, 

I have done a few trials, but it seems the Selected Year Value always uses the default value rather than the one selected in the slicer. I checked the Selected year value, and it equals the one from the slicer...

 

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

 

The value of the calculated column won't change as the slicer changes.

You can create a measure instead of column.

Like this:

 

Measure = IF(SELECTEDVALUE('Table'[year])=SELECTEDVALUE(Parameter[Parameter]),1,0)

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,
Community Support Team _ Janey

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks heaps 🙂