Calculate filter not working when adding dimension

Good morning,

Firstly, wishing you a merry x-mas! 🙂 

I'm working on a dashboard that it has to show different measures based on different subsets. There's a database with rows representing actions. All the rows have a column named Date that shows the date of the game. The subsets are:

Last_Game = MAX(database[Date])

Other_Games = database[Date] <> MAX(database[Date])

So, to represent the data of the last game, I used:

Pts/G_Last = CALCULATE([Pts/G], database[Date] = MAX(database[Date])) 

* With this CALCULATE, I take, from all games, the measure [Pts/G] for the subset created for the database[Date] = MAX(database[Date])

 

This is working when I represent the data alone but not when I add a column to see the same amount [Pts/G] separated by that column/dimension. The example below:

 

- When using the measure alone, the expected result is correct (78). (Image 1)

- When adding the dimension, the total is changing to show all games, ignoring the calculate filter. I tried also with KEEPFILTERS but not working [Pts/G_Last = CALCULATE([Pts/G], KEEPFILTERS(database[Date] = MAX(database[Date])))]. (Image 2)

 

Could anyone tell me how I could do it, please? Thank you in advance.