Forum Discussion
Solved
Dax Table ignoring context filter
Hey everyone, I have an unexpected behaviour when I create a calendar table, I would like to understand what am I doing wrong or at least the reason of the behaviour. I have created one da...
Hi Arentir
The Calendar Function does not work with changing measures. It's behavior is somewhat similar to the calculated columns. It is created once and the sliced measures may keep on changing, so it is not possible to create it on this way.
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
You have no relationships in your model so your slicer only affects the dates from one table. If you replaced the date in the slicer with the date from your created calendar table, then the slicer would affect that visual and not your original.