Dax Table ignoring context filter

[Arentir]

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 date table and two measures: Minimum Date = Min(Date) and Maximum Date = Max(Date).

When filtering date with a slicer, the filter propagates to the table and measures (so far so good :))

But if I create a Calendar table as the following: CALENDAR(Minimum Date, Maximum Date), then the filter is ignored!

Here is a link to the PBI file and a screenshot in case it helps 🙂

Thanks!

https://1drv.ms/u/s!As5oZCclkGkWgSNz5mF8zTNNKvUu

[affan · Accepted solution]

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

[Arentir]

Thanks for the explanation. I though I could have tables that react to filter but I guess it is just not the way it works

[HotChilli]

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.