Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to filter a calculated table?

I have a calculated table that calculates the COVID cases per week and the Sales per week and then merges them by week.

https://imgur.com/a/geAC2vI  

 

Now when I filter for example on a certain product or state, my sales drop (so my sales per week should drop). And for state level my cases should drop aswell.

 

However when I filter on state level, my sales get filterd but my calculated table does not update. What am I doing wrong?

 
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , you can join the new table with applicable tables/dimensions, and those slicers should work. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

    What is the relationship between the two tables? Usually you should relate the calculated table with the orginal table based on State. Then you should able to filter.

     

    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.