Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Problems creating calculated table from a slicer

Hello, I've been stuck with this issue for hours and I need help understanding why this solution isn't working.    What I want to solve is this:  I have a large table and based on a dropdown isol...
Need Help
littlemojopuppy's avatar
littlemojopuppy
Community Champion
4 years ago

Anonymous are you saying that the calculated table doesn't recalculate based on slicer selection?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Yes. I've tried with SELECTEDVALUE('Years (slicer)'[Year]), INT(SELECTEDVALUE('Years (slicer)'[Year])) and CONVERT(SELECTEDVALUE('Years (slicer)'[Year]), INTEGER) but didn't work. Any light with this BI variable?

    • littlemojopuppy's avatar
      littlemojopuppy
      Community Champion
      4 years ago

      Anonymous calculated tables and columns only recalculate when data is refreshed, not when slicers change.  What you're trying to do is not possible.  Sorry to be the bearer of bad news ğŸ˜•

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks for your time. It seems that I will change something of this model. How can I handle this solution?