Need to create a measure that counts the amount of weeks there has been training

[rlhim]

I has been trying to create a measure that calculates the sum of weeks they trained. They can train more than once a week but we only check if its been done or not.

I don't know if its better to have a boolean answer or a numeric answer.

I've been trying to do it with if, something along the lines of if(Week>=1, 1,0) but can't seem to make it work

My data looks more or less like this

ID	Name	Week	Date
1	Edwin	1	1/1/2023
3	Alexander	1	1/2/2023
2	Rachel	2	1/8/2023
2	Rachel	2	1/9/2023
3	Alexander	2	1/11/2023
1	Edwin	3	1/15/2023
2	Rachel	3	1/17/2023
2	Rachel	3	1/18/2023
3	Alexander	3	1/19/2023

The answer I want is 

Rachel 2

Edwin 2

Alexander 3

[parry2k · Accepted solution]

@rlhim try this measure:

Count Week = COUNTROWS  ( SUMMARIZE ( 'MyTable', MyTable[Name], MyTable[Week] ) )