Forum Discussion
Summarize table using a virtual table and Date Filter
MrBrown,
Calculated tables cannot interact with slicers because they are not dynamic; they are created at dataset refresh/query time.
However, what you can do is create the measure I shared above (if you didn't already have one), then follow the steps in this video. Using measures in a slicer is a commonly asked question so if that video doesn't work for you, there are a ton of other available resources out there. 🙂
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
MrBrown,
Calculated tables cannot interact with slicers because they are not dynamic; they are created at dataset refresh/query time.
However, what you can do is create the measure I shared above (if you didn't already have one), then follow the steps in this video. Using measures in a slicer is a commonly asked question so if that video doesn't work for you, there are a ton of other available resources out there. 🙂
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
thanks ! it's was exactly what i need! didn't know that we can use a measure as a slicer 🙂