Calculated dimension addmonths

[youss123]

Hello All,

I created a graph with monthyear between today-26 and today-13 with this caculated dimension : 

If([Date - Monthyear] < AddMonths(Max(TOTAL [Date - Monthyear]), -13),
If([Date - Monthyear] > AddMonths(Max(TOTAL [Date - Monthyear]), -26),[Date - Monthyear]))

The graph is correct like you can see below but when I want to make selections some of them don't work and show that there is no data to display .

Thank you in advense for your response

[Aditya_Chitale]

add the selection fields along with calculated dimension in a straight table and see if the calculated dimension values are  present for the field value selections.

Regards,

Aditya

[youss123]

Thank you for your response Aditya_Chitale , wen

before selecting

after selecting