Forum Discussion
eliasayyy
Memorable Member
Memorable MemberDax Calculation to go Backwards
Hello everyone i have a complex Ask. I have a visual which has 5 slicer each from seperate dim tables slicer 1: clinic site from dimSite table slicer 2: clinic contract from dimContract table sli...
Hi eliasayyy
Calculated tables and columns are not aware of slicer selections. They calculated once upon refresh, when modified, or the referenced measures/columns/tables have been changed. That aside, it would be easier for us to work on a solution if you provided a sample pbix, of course, with confidential data removed.
cengizhanarslan
Super User
Super UserCalculated tables are static — not filter-aware — so your existing approach won’t respond to slicers.
eliasayyyMemorable Member
Memorable Memberhello! i am aware of the limitations i just did this approach to help understand what i need. how do i solve this?