Dim_calendar not interacting with the column in the filter

[elcamino]

Hi,

I have a semantic model similar to this one. In my report I use as a filter dim_calendar[date] as well as a column called End_Date present in table 4.

My column End_Date is like this one:

End_Date =

IF(

    'Table4'[Type] <> 5,  -- Only for Type not equal to 5

    IF(

        ISBLANK('Table4'[Out_Date]),

        'Table4'[End_Date_old],

        'Table4'[Out_Date]

    ),

    BLANK()  -- Return BLANK if Type is 5

)

However, when i put this column in a slicer filter it doesn't update it when i change the date in the dim_calendar[date] filter. Moreover, the minimum value in the slicer filter should be the one present in dim_calendar[date], but it is not. Nonetheless, the maximum value in the slicer is the correct one.

Thank you for your help.

[amitchandak · Accepted solution]

@elcamino , A column is loaded at the type of data load or creation(when you add it), and it is static post that, row values will not change because of slicer values. You can create a measure instead.

[v-menakakota]

Hi @elcamino ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-menakakota]

Hi @elcamino ,

I wanted to check if you had the opportunity to review the information provided by @amitchandak . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-menakakota · Accepted solution]

Hi  @elcamino ,

I hope the information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[amitchandak · Accepted solution]

@elcamino , A column is loaded at the type of data load or creation(when you add it), and it is static post that, row values will not change because of slicer values. You can create a measure instead.