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.
Super User