Getting max value of a column fixed for every row

[Nini1]

Hello everyone,

I'm a new user of Power BI and need your help to solve the problem.

I have a data of customer who have unique identifier and corresponding date field. 

I want to create field  max date per client (takes maximum value noted per each client) and max date(takes maximum value for all the data). I tried to use max (date) function to create the last field but for each row I get different max values but I want max value to be fixed for each row.

Could you please help me to solve this issue?

Thank you in advance

[smpa01 · Accepted solution]

@Nini1 

use the following measures

maxDatePerClient =
CALCULATE ( MAX ( tbl[date] ), ALLEXCEPT ( tbl, tbl[id] ) )

maxDateAll= CALCULATE ( MAX ( tbl[date] ), ALL(tbl))

[Nini1]

Thank you very much!