Forum Discussion

ChrisTof's avatar
ChrisTof
Frequent Visitor
3 years ago
Solved

Filter visual table with a measure not dynamically updated

hi, I'm using the visual table below with this measures.   Number of days Type 1170 Red 804 Red 511 Green 355 Orange 346 Orange 288 Green 274 Green 268 Red  ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Remember that the measure is recomputed each time you interact with the visual. So when you remove Green from the filter context your average value shifts and that then results in only one of the Reds showing. It's working as designed.

  • ChrisTof's avatar
    ChrisTof
    Frequent Visitor
    3 years ago

    I agree with you that it's working as designed but it doesn't respond to my use case.

    So how can i do that ?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      Use disconnected tables and create measures that can serve as visual filters.