Forum Discussion
slicer on report does not refresh calculated table
Yeh, calculated tables, as in Modeling/New Table/Type stuff in dax, is a "static" table. It will not respond to filters.
The error you mentined is not relevant in terms of the solution but, it is just telling you that niether of the two columns you are trying to join on has unique (non-repeated) values.
The solution, if you want your table to respond to filters, is to include the Calculate Table function in the target Measures.
As far as I know, DAX created tables are static and do not respond to slicers from the original table and only update upon refresh. I had the same question during my early DAX days.
There must be a way in DAX to get the values from the filters or the slicers then perform whatever the calculations may be accordingly. Wizards are not there always. That's what I am trying to find.
one way is to create a measure in a fact table or a pivot table that gets a SELECTEDVALUE from a slicer or table, then apply that measure in a filtered context DAX, whether implicit or explicit.