Problem with measure

[Ronning]

 Hi 
I have touble to create Measure1 & Measure2 in the picture below. Hope someone have any ideas Thanks // 

[DOLEARY85]

Hi,

you'll need your date field to be converted to an actual date format first - then you can use:  

Measure = CALCULATE(FIRSTDATE('Table'[Date]),'Table'[Profession]="Analyst",ALLEXCEPT('Table','Table'[Patient]))

Measure 2 = var datecheck = CALCULATE(FIRSTDATE('Table'[Date]),'Table'[Profession]="Analyst",ALLEXCEPT('Table','Table'[Patient]))

return

if(isblank(CALCULATE(COUNT('Table'[Date]),'Table'[Date]<datecheck,ALLEXCEPT('Table','Table'[Patient]))),0,CALCULATE(COUNT('Table'[Date]),'Table'[Date]<datecheck,ALLEXCEPT('Table','Table'[Patient])))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Ronning]

Thanks for youre help, i still have an issue.  I get an error (duplicate date as been given to FIRSTDATE).
Then i tried to make a datetable an connected it to the date column. But i only get the lowest date that exists for every row