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.
I have the source table with a student start date and end date. I need to calculate how many days the student was present each month. So I created calculated columns for each student each month in the source table. Then I wanted to do a line graph that shows totals by month. But since the months are individual columns within the table I couldn't build a line graph. So I created a calculated table that computes the totals for each month.
Calculated table has monthname, totaldays in that month, program
But now am unable to filter the line graph so it filters by program.
Hope I did it right! Thanks.
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.
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?
