Forum Discussion
Using VARS with CALCULATETABLE
Could someone please explain to me why this works: LastPurchaseDates = VAR Churnvalue = 365 RETURN CALCULATETABLE( ADDCOLUMNS( SUMMARIZE( Shipments, Customers[CUST_CODE], "Total Sales",...
A calculated table cannot be dynamic based on user selection since calculated tables (and calculated columns) are only calculated once each time the data model is loaded or refreshed rather than in response to slicers or filters from the report page.
On the other hand, this is what measures are designed to do. So your ultimate goal is very likely possible--you just need a slightly different approach.