Summarized table based on dynamic selections

Hi Shrey03 ,

Calculated tables don't respond to slicer selections. They are updated only when the refrenced tables are updated, when the formula is modified or upon data refresh. You can use visuals instead to dynamically change the view and filter that using a slicer but the referenced table must have all the rows needed.