Power pivot - how to count data after a category change

Hi everybody, i'm using power pivot for builing a report, these are my data:   Project table:   Project   Category Project value Date A 1 1000 01/01/2023 A 1 ...