Forum Discussion
Solved
Dax 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.
Calculated tables are static — not filter-aware — so your existing approach won’t respond to slicers.
hello! i am aware of the limitations i just did this approach to help understand what i need. how do i solve this?