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.
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.
An example of using the calculate table function in target measures would be great, if you happen to see this and have one available.