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.
Responsive ResidentYeh, 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.
RobertSlattery wrote:
The solution, if you want your table to respond to filters, is to include the Calculate Table function in the target Measures.
Sorry I just found this, and I'm having the same difficulties, could you elaborate a little bit more on this?