Max value in a measure is ignoring the filter

[roshan84tech]

I have a measure which takes max(Sales) . I have created a table.

Month.     Max(Sales)

July.            XXX

August       XXX

I have a filter date(YYYY-MM-DD), when i filter out particular dates in a month the max(sales) value does not changes according to the filtered out dates.

[SunilChauhan]

Does Month and Date are Related? if Date and Month are not related it will not impact on table.

if Its Related then try selecting other values in Dates

[roshan84tech]

So, i have a field date which shows dates in (yyyy-mm-dd). In the table to show month i have taken[date.autoCalendar.YearMonth]

[SunilChauhan]

so want to Select Latest month for bookmark? please share some sample if possible

[Lakshminarayanan_J]

@roshan84tech 

Kindy check whether the autogenerated date and your  table month are interlinked , if not the data wont match 

1. How you are matching the date field with month field ?

2. How the data model linked between both?

[roshan84tech]

There is only one field date. The month is coming from the date field itself using the expression - [date.autoCalendar.YearMonth]